Running a Macro to Open and Find form with like fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that this has been explained but I need the dumbies version. I have a
form with a transaction number field and im trying to create a macro that
will open another form and filter it to the field transaction number in the
new form. In summary I need to know formula for the where condition.
 
Aaron,

The Where Condition of the OpenForm action will be something like this...
[transaction number]=[Forms]![YourFirstForm]![transaction number]

Another possible approach to this, is to make the second form based on a
query, where you put the equivalent of...
[Forms]![YourFirstForm]![transaction number]
.... in the Criteria of the transaction number field in the query. Then
you just need a simple OpenForm action, and the correct record will be
shown automatically without the need for a Where Condition argument.
This assumes the first form will remain open while you are using the
second form, and also assumes that your application does not require to
open the second form from anywhere else.
 
Back
Top