AutoLookup Query doesn't autofill my fields

[CLC]

I have 2 linked tables and have met the 4 criteria in the help menu to make
sure they autofill, but when I enter new data, the other fields don't
autofill. I don't know what info you need from me to help solve the issue.

The join field in the one side of the relationship (MemberID) is the
primary key and it is randomly filled. The database is also replicated, if
that makes a difference. I'm not sure how to copy the query itself into this
message.

Thx.

 

[Duane Hookom]

Are you expecting other field values from the lookup table to fill into
another table? This would result in storing information like FirstName in
two or more tables. This isn't generally recommended.

 

[CLC]

Unfortunately, I do have 2 identical fields in 2 tables. Someone else setup
this database for me and I'm not sure how to get out of that situation. Is
there a way to autofill the fields? At least that way, I know the data will
be exactly the same in the 2 tables?

 

[Duane Hookom]

You might want to look at the Order Details subform in the Northwind
database. The Unit Price value is taken from the Products table and inserted
into the Order Details table.

I generally use a combo box containing a row source like:
SELECT MemberID, FirstName, LastName, Phone
FROM tblMembers
ORDER BY FirstName, LastName;

Then use the after update event code of the combo box to set the values of
the duplicate values controls:

Me.txtFirstName = Me.cboMemberID.Column(1)
Me.txtLastName = Me.cboMemberID.Column(2)
Me.txtPhone = Me.cboMemberID.Column(3)