D
DB via AccessMonster.com
I know this may not be the best way to set it up, but its the way that my
boss wants it.
I have to forms both with info from one table:
-Returns 1 - Data Sheet View which is the main form (Contains 5 Fields of
Info with RMA, PN, Serail Number, etc)
-Returns 2 - Justified with all the fields from the main table, and more
specific on just that one record
What I need to do is be a be able to click on the RMA field in Returns 1 and
have it open directly to the coorisponding record in Returns 2. So I set up
an OpenForm macro (just one line) on click that is suppose to open to that
record, but it only opens to the first record every time. I am new to access
and VB and have never built a database before.
Macro:
Action: OpenForm
Form Name: Form1
View: Form
Filter: (blank)
Where Condition: "[RMA Number]="&[Forms]![Returns1]![RMA Number]
Data Mode: Edit
Window Mode: Normal
boss wants it.
I have to forms both with info from one table:
-Returns 1 - Data Sheet View which is the main form (Contains 5 Fields of
Info with RMA, PN, Serail Number, etc)
-Returns 2 - Justified with all the fields from the main table, and more
specific on just that one record
What I need to do is be a be able to click on the RMA field in Returns 1 and
have it open directly to the coorisponding record in Returns 2. So I set up
an OpenForm macro (just one line) on click that is suppose to open to that
record, but it only opens to the first record every time. I am new to access
and VB and have never built a database before.
Macro:
Action: OpenForm
Form Name: Form1
View: Form
Filter: (blank)
Where Condition: "[RMA Number]="&[Forms]![Returns1]![RMA Number]
Data Mode: Edit
Window Mode: Normal