Past Deadline: Need help selecting current record from continous form

  • Thread starter Thread starter Rob Cline via AccessMonster.com
  • Start date Start date
R

Rob Cline via AccessMonster.com

I am developing a database to access telephone messages. My problem is that
when the user selects a category from a combo box, certain fields of the
message under the category selected such as, Sender, Subject, and Date
Entered are displayed in a continous form, in which I have added a command
button to the row so that the user can select the message they want to view
in its entirety. However, I am unable to pass the mess_id from the
continous form to the message review form using the command button because
their is no link between them. Any help someone can provide will be greatly
appreciated.
 
However, I am unable to pass the mess_id from the
continous form to the message review form using the command button because
their is no link between them. Any help someone can provide will be
greatly
appreciated.
Click to expand...

You don't need a link of anytime here, but you most certainly do need to
include a key value in the continues form that identifies each individual
record. You don't have to place this id in the continues form..but it HAS to
be part of the continues forms data. So, if you fill that continues
form..make sure the "ID" of each record is included in the query used.

It is then a simple matter to place the following code behind the button:

docmd.OpenForm "frmMoreDetals",,,"id = " & me!id

The above assumes a key id of "ID" which most tables have, but just change
"ID" to whatever you use as the key id for the reocrd.

I use the above code all the time...and here is some screen shots of such:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
Back
Top