M
Matt K.
I have a database that was imported from Excel.
I want to enter a search criteria in a text box on a form, press a command
button labeled SEARCH which runs a query and have the resulting records
listed in a subform. I have looked through a lot of these posts for similar
examples. I know it can be done as I have seen screenshots provided by Albert
Kallal elsewhere in this board. I have absolutely no experience with VB,
that's why I am trying this with Access.
I have actually got the query to run and give me correct records based on my
query. The problem is how the records are displayed...a new datasheet opens
instead of the results being displayed in my subform, which I set up as a
continuous form with a view/edit button that can be pressed to see/edit
everything about the record.
I imagine this is a classic rookie mistake... HELP
I want to enter a search criteria in a text box on a form, press a command
button labeled SEARCH which runs a query and have the resulting records
listed in a subform. I have looked through a lot of these posts for similar
examples. I know it can be done as I have seen screenshots provided by Albert
Kallal elsewhere in this board. I have absolutely no experience with VB,
that's why I am trying this with Access.
I have actually got the query to run and give me correct records based on my
query. The problem is how the records are displayed...a new datasheet opens
instead of the results being displayed in my subform, which I set up as a
continuous form with a view/edit button that can be pressed to see/edit
everything about the record.
I imagine this is a classic rookie mistake... HELP