G
Guest
Hi!
I have my app start with a form configures as a datasheet view of the
customers in the table, displaying only a few fields / columns. When the user
clicks on the last name field of any record, I open a form which is a columar
view of the customer record showing all the fields for one customer on the
screen, also allowing the user to select next/previous record etc.
When the user clicks on the last name in the datasheet, I want to open the
columnar form as is happening, but I want the record displayed to be the one
that the user cliked on, not the first record. I am opening the columnar form
using the click even in the datasheet form in the last name field. I just use
a DoCmd.OpenForm statement.
I hope this is clear. Please help!
I have my app start with a form configures as a datasheet view of the
customers in the table, displaying only a few fields / columns. When the user
clicks on the last name field of any record, I open a form which is a columar
view of the customer record showing all the fields for one customer on the
screen, also allowing the user to select next/previous record etc.
When the user clicks on the last name in the datasheet, I want to open the
columnar form as is happening, but I want the record displayed to be the one
that the user cliked on, not the first record. I am opening the columnar form
using the click even in the datasheet form in the last name field. I just use
a DoCmd.OpenForm statement.
I hope this is clear. Please help!