LOOKUP Field

[tabbycat1234]

Can someone tell me of a good tutorial or a good way to make a looking field.



I went into design view in my form, selected the combo box. I was under the understanding that three choices was suppose to come up but I only have two choices.

Any help would be appreciated

[pbaldy]

The form needs to be bound to a table to see the third option. If yours is bound to a query, you can create a form bound to a table and use the wizard, then you can copy the code the wizard creates to your real form.

[tabbycat1234]

What do you mean that it needs to be bound to a table? I have relationships set within my tables but what do I need to do to bound it to a table?

I want to be able to look up the first and last name of the students. What is the best way to do that?

[pbaldy]

I'm saying that the record source of the form has to be a table for the wizard to offer the third option. The combo is fine for looking up the names and going to that record.

[tabbycat1234]

The record source is a table. I am still not getting the third option.

[pbaldy]

I've never seen it not offer the third option in that case. This is the type of code the wizard will build (this is a text field; you wouldn't want the single quotes around a numeric value):

Dim rs As Object

  Set rs = Me.Recordset.Clone
  rs.FindFirst "[Acc_ID] = '" & Me![cmbFindAdvDr] & "'"
  Me.Bookmark = rs.Bookmark
  Me.cmbFindAdvDr = ""

[tabbycat1234]

I have not gotten into how to write codes. Should I upload my database on here so I can learn to do it or should I just try to figure it out another way

[pbaldy]

Here's where code goes:

http://www.baldyweb.com/FirstVBA.htm