Avatar of Ken Milam
Ken Milam
Flag for United States of America asked on

Add where condition to Form's button

I have a basic Form question -

For lack of not knowing any better, I have created multiple copies of the same form to handle different scenarios.  For example, I have a form name f-order and I have second similar form named f-order_edit.  f-order_edit is opened when a user clicks on a button (located on a third form), which uses a criteria in the f-order_edit underlying query to one return one specific record.

There is probably a better way to handle these two scenarios with a single form + some sort of "where" expression that is associated with the button...right?   Where would this code be placed...on one of the button's events?

Thanks,
Ken
Microsoft Access

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy