Refresh Query using Value on Form?

[AKQTS]

I have a parameter query where it asks the user for an order number which then displays the parts on that order on the form.



Due to a new feature, I would like to refresh that query without having to reenter the query parmeter.

Can I refresh a parameter query using a previously entered value as the parameter value?

This query is the record source for a form so I was not wanting to change this, but pass a value into the parameter required to run the query.

[slave138]

One of the easier ways is to have the user enter the values in a form field instead of using a pop-up parameter.

• Use the current function to open a small launcher form asking for the parameter which also launches the desired order form.
• Edit the query to get the parameter from the launcher form field.
• The launcher form with the stored parameter can be left open with the parameter so each time the query runs it can pull the value from the form

You might also be able to do it using a pop-up parameter:

• Setup a query which initially populates the form via a pop-up parameter.
• Pass the value to a hidden field on the form.
• Create a similar query to read that hidden value as the parameter
• In whatever event would refresh the query, change the record source for the form to the other query.
• Use Me.Requery to refresh the data

I have used the 1st method many times before. I haven't tried the 2nd method but it seems like it could work.

[AKQTS]

I am trying your second method above. The query alone works great, but my code keeps freezing up the program.

DoCmd.Echo False, ""
DoCmd.SetWarnings False
Forms!Reject_Record.RecordSource = "Reject_record_Query_Refresh"
DoCmd.OpenQuery "Reject_record_Query_Refresh", acViewNormal, acEdit
Forms!Reject_Record.Refresh

[slave138]

You have a number of commands which don't seem to relate to what you are trying to do (unless there is more which you haven't elaborated).

The first two lines should not be necessary, nor should the 4th unless you are trying to open a seperate query on top of everything else.

I would use a Me.Requery (or Forms!Reject_Record.Requery) instead of Refresh.

Comment out the 1st, 2nd, & 4th lines in your code (and switch to Requery) and see if performance improves. If it does, uncomment each line until you find the source of the delay.

Also, you should remember to turn the Warnings back on after performing your actions.