I have a set of 5 forms, each providing student data for a different degree program. There is a sixth form, BasicInfo, which keeps track of contact information. I have the name fields from BasicInfo connected to the name areas of all the other tables, but now what I need is a combo box at the top of EACH form which allows me to select a name from the preexistent list of names and have the form fill in with the existing data so I can edit or remove pertinent pieces.
I've tried many, many things.
My most recent attempt:
Code:
Me.AllowEdits = True
On Error GoTo ProcError
DoCmd.FindRecord Me!cboFindRecord, acEntire, True, acSearchAll, , acCurrent, True
ExitProc:
Exit Sub
ProcError:
MsgBox "Error: " & Err.Number & ". " & Err.Description
Resume ExitProc
The code used to be as simple as:
Code:
DoCmd.FindRecord Me!cboFindRecord,acEntire,True,acSearchAll,,acCurrent,True
but that didnt' work either.
cboFindRecord is the name of the combo box, the fields in question are:
BasicInfo.Last_Name
BasicInfo.First_Name
the primary key is BasicInfo.BasicInfoID