Select record based on selection in combo box

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

Guest

I am trying to do what seems like a basic command. The database is a
tracking system for state/federal grants. The users want the ability to
select a grant number (BOCID) from a combo box and select either "OK" or
enter and then have the form they are using to enter new grants to pull up so
they can either edit, or print.

How do I do this?? I have my combo box. I just need help linking it to the
form they use to enter new grants.

Thank you in advance for any direction you can give me.
 
Hi Loreal,

Use something like this in the Click event procedure of the button,
where frmGrant is the name of the form you want to open, and cboBOCID is
the name of the combobox:

Docmd.OpenForm "frmGrant", acNormal, _
"BOCID = '" & Me.cboBOCID.Value & "'"

If BOCID is a number field rather than a text field, omit the first '
and the terminal & "'" .
 
Back
Top