HELP!!!!!!

  • Thread starter Thread starter Nate
  • Start date Start date
N

Nate

Can someone please give the Macro overview for the following task.

On a form I have a text box and a button.
I need to be able to click on that button and look up the number in the text
box in its feild from a table. The I need that record to open in an
exsisting seperate form for editing and saving.

PLEASE PLEASE
 
Nate said:
Can someone please give the Macro overview for the following task.

On a form I have a text box and a button.
I need to be able to click on that button and look up the number in the text
box in its feild from a table. The I need that record to open in an
exsisting seperate form for editing and saving.

PLEASE PLEASE
Click to expand...


Create a query which will control the record on the form you want to open.
In the criteria for the field you are searching for from your search form
enter:
[Forms]![FormName![Text#]
[FormName] is the name of the form you are searching FROM
[Text#] is the text box number on the search form.

Create a macro. The order of events is
Open Query - the query you just created
Open Form - the form you will be using to edit your data. Set the filter to
the query you just opened.
Close - Form - the form you were using to search
Close - Query - your filter query (you don't need it open anymore as it will
have found the required record.
Stop Macro
 
Back
Top