Re-opening Form from within it's self

[carlisle]

Hi,
I'm new to this site, so hello.

I am currently creating a database for the company I work for, and having alot of problems as I go.

At the moment, I am stuck with a form problem. I have created a number of search Querys (using [Enter SerialID] ect. into Criteria). I have then created a form (locking and disabling all fields) to show the data. As the process will be repeated alot each time, I need to find a way to re-open the form, from within the form, so that the dialogue box reappears to enter the next ID to search.

Any ideas?

Thanks, Ben

 

[Len Boorman]

Generally I use the two form approach

Form 1 is where the user selects serial number from a combo box.

On click property open form 2 with results using combo box as query criteria.

Close button closes and reopens form 1 and then closes form 2

Len

 

[KeithG]

You could also requery the form

 

[carlisle]

Thanks, I'll give it ago and see what happens, hopfully I won't need to reply to this again...

 

[jkl0]

Another way would be to use combo boxes and a subform to show your results.