HOW CAN I MAKE A PARAMETER QUERY RUN AGAIN ON A FORM?

[thedrumdoctor]

I have a form which starts with a parameter query on a combo box and finishes
with an ‘Add New Record’ button.

The parameter query asks for a text phrase and returns options that match
text inputted. These results appear in the combo box list.

An item can then be chosen from the list after which, other criteria on the
form can be completed. The last stop on the form is the ‘Add New Record’
command button. Once this is pressed the record is added to my table and I go
back to the start of the form.

*PROBLEM*

How can I make the parameter query run again at the start of the form? I
have tried using a ‘Refresh Form Data’ command button but this seems to mess
up data entered on previous records. Is there an extra event I can add to the
‘Add New Record’ button?

 

[Roger Carlson]

Try
DoCmd.Requery


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[thedrumdoctor]

Thanks, that did do what I needed but it has also thrown up other
discrepancies in my methodology which makes me realise, that it's one thing
building simple relational databases, but if you want to make them do
anything extra then a course in VBA and Access development is an absolute
must.