Problem with Access Form

[marrpis]

Well this is a little complicated.



My table is called Maintenance_Fees and has the following fields (SB_ID, Member_ID,ML_Last_Name1, ML_FirstName1, Year_1994....Year_2025(numeric fields)

and what i tried to do in the form, was to connect the fields
SB_ID, Member_ID, ML_Last_Name1 and ML_FirstName1 with the fields to another table "Members_List" so it would be autofilled after i chose the SB_ID, which i did with After Update Event

Member_ID = DLookup("Member_ID", "Members_List", "SB_ID=" & SB_ID)

ML_Last_Name1 = DLookup("ML_Last_Name1", "Members_List", "SB_ID=" & SB_ID)

ML_First_Name1 = DLookup("ML_First_Name1", "Members_List", "SB_ID=" & SB_ID)

The problem is that when i choose one SB_ID member, then it just autocompletes the fields i said, but the other fields i have are always the same...

How can i connect all the fields? Or do I have to do it another way? I want when the all the fields to be updated automatically

HELP AND THANKS...

[June7]

Should not be saving the names in Maintenance_Fees, only the Member_ID. Use a query to join the tables when you want to view other info from related records. This is major principle of relational database - don't duplicate data.

Where are you using the DLookups? In textboxes on form?

[marrpis]

I use DLOOKUP in Maintentace_Fee Form

[marrpis]

I haven't also defined that : SB_ID, Member_ID, ML_LastName1 & ML_FirstName1 are in my primary table Members_List and SB_ID is the Primary Key there.

I haven't ever used a query to relate forms but i will try.

[marrpis]

Sorry the answer to the question is that i have made a combo box for SB_ID in the form where i use DLookUP

[June7]

The DLookups are not best approach. Combobox should not have a DLookup anyway.

Member_ID should be a multi-column combobox with a RowSource that has columns for the ID and name, like:

SELECT Member_ID, ML_Last_Name1 & ", " & ML_FirstName1 As MemeberName FROM Members_List;

Then set combobox properties:
ColumnCount: 2
ColumnWidths: 0";2"
BoundColumn: 1
ControlSource: Member_ID

Review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the 3 on comboboxes in the Access Forms: Control Basics section.