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?
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?