Enter Parameter value?

[hlcarlin]

Hello,

I am trying to store a primary key value from a drop down box and opening a form that will show the data corresponding to that primary key but when I click on the button I set up, a pop-up box reading Enter Paramater Value appears and the link between forms does not seem to function...

[orange]

Please show us some code.
Often in a drop down you show the data,and when you select it, you get the PK or some numeric Id value.

[hlcarlin]

Im sorry I know absolutely nothing as to VBA programming... I am trying to complete this using only the access interface.

I will try and explain what I have done in order to give you a better understanding of my situation:

Tables:

1) Menu
--Field: PK_Menu (This is the primary key)
--Field: StoreParticipantPK

2) Participants
--Field: PK_Participants (This is the primary key)
--Field: ParticipantNumber
--Field: ParticipantName

Forms:

1) Main Menu (this form is linked to the table: Menu)
On this form, I have created the drop-down box using the wizard, linked to the table Participants, showing the ParticipantName values and storing the PK_Participants value in the Menu table under StoreParticipantPK.

I have also set up a button used to open the form SeeParticipantInfo (see below). This button links the value of the DropDown box to the PK_Participants field in the Participants table and I have selected the Open to a Specific Record option.

2)SeeParticipantInfo (this form is linked to the table: Participants)
On this form, I have two text boxes, one for the ParticipantNumber field and the other for the ParticipantName field.


The error occurs when I click on the button used to open the SeeParticipantInfo form.

Thank you

[orange]

Are you using drop downs at the Table level? I'm not clear how you created the dropdown.

see this http://access.mvps.org/access/lookupfields.htm

Did you use the Form wizard and your table name to create the form?