Populate subform with query results

A

apeleg

Joined
Jul 31, 2012
Messages
2
Reaction score
0
Hi all...
I am using a main form with a subform, a text box, and a run button (see picture below). I want the user to enter a number that will be used by the query and will populate the subform with the search results. I am getting the correct search results only if I click the refresh button. It seems like the Run button is not linked to the query/subform and I don’t know what properties the text box/Run button/subfrom should have.
Thank you very much!
Anat
Capture.JPG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form query help 0
Populate query in a subform based on selection from combobox in main form 0
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Run Query on Subform Using VBA Macro Button 1
Pop up form is not populating query results 0
PLEASE HELP: Refresh a subform 5
Access Sub form opens before the main form in MS Access 0
Prompt for a subform text field 2

Top