Query-Search-Populate Form

B

Big Tom Tuttle

Maybe someone can help here? I have read multiple postings out there on how
to search using a combo box or text box unbound. I have 2 forms, 1 query,
and 1 table named respectively:

form(s): "frmMain" & "frmCrit"
table(s): table 1
query(s): query1

I have a unbound combo box on "frmCrit" with a command button that is tied
to "query1" for my search form. On my other form "frmMain" I have a command
button that opens form "frmCrit". <my search form>

When I type within the open box to search for matching records of "table 1"
my search function works "however", it only brings up a table with the
matching record highlighted within the table. It does'nt actually populate
my "frmMain" with all the corresponding record information.

What I am trying to do is basically search records so that if there is a
unique key "-ID" already in existence that the form is populated by the
tables matching records.

It should be noted that my Query Properties have "Unique Records" set to NO.
Should this matter in populating the form?
 
R

Rick B

8 posts is a bit much. Chill out and wait for an answer. Someone will get
back to you.

You should try to not post the same question in multiple groups. If someone
answers your question in one group, another person might invest their time
and effort into answering it in the other group. This means two people
spend time (oftne giving the same answer).
 

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

Top