List or Combo Box ?

[Lbs]

Windows 7, Access 2000
I want to use one or the other to get info out of a table by clicking on a word in the box.


The table has record 1,2,3,4,5 ect. the form box has a combo box that gets the records list from the table. I want to set it up so if I click on record 1 it will open a different form and show that record?

[June7]

VBA code in the AfterUpdate event of the combo or list box.

DoCmd.OpenForm "form name", , , "field name=" & Me.combo or list box name

[Lbs]

DoCmd.OpenForm "Beef", , , "field name=" & Me.combo1

Private Sub Combo1_AfterUpdate()
DoCmd.OpenForm "Beef" this part opens the form, but the rest of it causes an error , , , "field name=" & Me.Combo1
End Sub

[orange]

What error message exactly?
What value was selected in the combobox?

[Lbs]

In the combobox there is a list
Chi
bfs
spg
Pe
They all come back with compile error

[orange]

Can you post a sample of your database-- just enough data to show the issue?

[June7]

Instead of 'field name' use real name from your table. I used a generic alias because I don't know your data structure. Also, the data is text so need apostrophe delimiters.

"field name='" & Me.Combo1 & "'"

[Lbs]

How do I post a copy of data base?

[June7]

The Attachment Manager is located below the Advanced post editor.

[Lbs]

It comes back saying the file is over 500KB
and doesn't attach.
In my table I have these records
Chi
bfs
spg
Pe
On the form I have 1 combobox it is populated from the table. When I open the combobox and click on one of the list I want it to open frmBeef and show that file.

"field name='" & Me.Combo1 & "'" comes back needs a number 1 for chi 2 for bfs Ect.

[June7]

Did you run Compact and Repair? If still too large can zip. Zip of 2mb allowed.

Did you change 'field name' to real name from your table?

What does 'comes back needs a number 1 for chi 2 for bfs Ect' mean?

[Lbs]

Error message in debug

[Lbs]

I hope this attached

[orange]

I'll look later

[June7]

Your data structure is wrong. You have 9 tables with identical fields. These can be one table with one additional field: RecipeType. The values in this field would be: beef, cake, casserole, chicken, deserts, pastry, pie, pork.

Check this http://office.microsoft.com/en-us/te...001018635.aspx

Regardless of the above, the VBA code (according to prior instructions, except no apostrophe delimiters because turns out the criteria is numeric) should be:
DoCmd.OpenForm "Beef", , , "ID=" & Me.Combo1