Find Form Record

[GaryF37 via AccessMonster.com]

I don't know if this is the correct verbage - But what I have is a Form based
on a table. I want to find a "form record", by having the user be prompted
to enter each control and have the form with the selected record show up.

Thanks for your help

Gary

 

[Beetle]

You said you want the user to be *prompted to enter each control* and then
have the form move to the specified record. Does this mean you want the user
to input values into multiple controls before moving to a record? If so, how
many?

If I've misread your post and you only want them to enter a value in one
control, then one option would be to use a combo box and have them select a
pre-existing value from one of the fields in your table. you can use the
combo box wizard for this if needed.

 

[GaryF37 via AccessMonster.com]

ya, there are two controls needed to find the actual record in the form, one
is the project # and the other is the CTC# - which the project required a
"ctc" done every month

You said you want the user to be *prompted to enter each control* and then
have the form move to the specified record. Does this mean you want the user
to input values into multiple controls before moving to a record? If so, how
many?

If I've misread your post and you only want them to enter a value in one
control, then one option would be to use a combo box and have them select a
pre-existing value from one of the fields in your table. you can use the
combo box wizard for this if needed.

I don't know if this is the correct verbage - But what I have is a Form based
on a table. I want to find a "form record", by having the user be prompted

[quoted text clipped - 3 lines]

Gary

 

[Jeanette Cunningham]

Hi,
have a look at the sample search form on www.allenbrowne.com
The search form can be downloaded with all the code.

Jeanette Cunningham