Problem with a form

[chrlwhttkr]

I have a form which has 2 values:
Group ID
and Group Member ID
there are two tables linked to these:
tbl_Groups
tbl_GroupMember.
How can I get the group member field to only show group members from the group ID that has been inputted in the form before the group member ID.
The group member is a combo box which contains group id, group member id, first name and last name
Anything would be appreciated.
Thanks very much

 

[jdraw]

Please post the table designs and the SQL you are using (form recordsource, and combo rowsource).

 

[MajP]

Search on this forum for Cascading Comboboxes

basically on the Enter event of the GroupMember Combo something like

cmboMember.rowsource = "Select group id, group memberid, firsname, lastName from tbl_GroupMember where GroupID = " & me.CmboGroupID

 

[chrlwhttkr]

Please post the table designs and the SQL you are using (form recordsource, and combo rowsource).

I am a beginner can I just post my database?

 

[arnelgp]

you will not be able to post your db.
you need at least 10 post to be able.
you can upload it in dropbox or onedrive and post the link to the db.

 

[chrlwhttkr]

I had a look at Cascading Combo Boxes and managed to fix this problem. I have another issue now though. I have parameters in a query as from_date and to_date and I want these to be inserted into a label in my form

you will not be able to post your db.
you need at least 10 post to be able.
you can upload it in dropbox or onedrive and post the link to the db.