Trying to update form by clicking on list

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

Guest

I have a list box that shows the account balance in a statement form. I want
the form to bring up the record that I select on the list box. The list box
is displayed on the form at all times. I want the properties to bring up
that record when the selection in the list box is double clicked. When I go
to properties, it prompts me to create a macro.
The macro that I believe is the most appropriate is the Goto function.
However, I don't know how to tie to the record being clicked on the list box.
It wants a specific number for a specific record. I want it to bring up the
record that I double click. Any help would be most appreciated.
 
RMeyer

The macro action applicable to this task is the FindRecord action. Have
a look in Access Help on this topic (you can just enter FindRecord in
the action column of the macro designer, and then press F1). Then post
back if you need any further specific help.
 
What do I need to put in the findwhat box to bring up the selection in the
form. I want it to pull it up based on the ID.
 
RMeyer,

In the Find What argument, you would enter the equivalent of...
=[NameOfYourListbox]

This assumes the Bouind Column of the listbox returns the ID.

Before the FindRecord action in the macro, you will need to do a
GoToControl action to set the focus to the ID on the form.
 
Back
Top