Macro

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

I have a table called "mainform" with a subform in it.
The form "mainform" reference a table called "info" the
subform references a table called "Details". The fields
in the subform are not editable though the table. I set
up a macro that opens a form called "formdetails" when a
text box in the subform is double clicked. This form has
the data displayed in the subform. This allows the data
to be modified easily. My question is how can i tell the
macro to open "formdetails" to the record shown in the
subform? The relationship between the two tables is the
field "Name".

Thanks for your time and help
 
-----Original Message-----
I have a table called "mainform" with a subform in it.
The form "mainform" reference a table called "info" the
subform references a table called "Details". The fields
in the subform are not editable though the table. I set
up a macro that opens a form called "formdetails" when a
text box in the subform is double clicked. This form has
the data displayed in the subform. This allows the data
to be modified easily. My question is how can i tell the
macro to open "formdetails" to the record shown in the
subform? The relationship between the two tables is the
field "Name".

Thanks for your time and help

.
Click to expand...
Hi Jason,
this should be posted to the macros newgroup...

Anyway use the macro action argument 'Where Condition'.
For example
[Name]=forms![mainform]![subform]![name]

Note. you may encounter ambiguous naming problems using a
reserved field/control name, as 'name' is a property.

Luck
Jonathan
 
Back
Top