Evil Access Stuff Lookup values in your tables are evil.

But yes it's because it's a number field. I'm assuming Member_TBL has their real names in it? If so, In your query photo you should be able to get the string version by bringing in Member from Member_TBL

Hi Adam, Member_TBL has their real names in it and I did as  you mentioned it works when you run Query, in the form I have a Search Button for Members that I am picking from the Query as dropdown and once the member is selected it show all the projects that member is a part of. In form it is not showing the Member list.

Change the control source there to Member_TBL.Member if you've brought in the member field from that into the query. Or even better just give it an alias. Go to where you have the member in the query from the _TBL and change it to MemberName: Member_TBL.Member and then change the control source to MemberName

Hi Adam,
Now, It is showing the Member in the List and when the query is run you can see the results, however the form it dies not display the projects for the selected member.

Delete the combo box and start over, guessing you have something in the macro going funky now that you've changed that. Select the ID field and the MemberName for the 2 fields

When I add new combo box under the option where we select field it does not display the ID anymore only MemberName

So your doing new combo box, find a record thing right? Then in next page you can't select the ID and the MemberName? Page after that should be hide the key field.

The form is based off of the query too correct?

A filter may be easier. Try this Filter Records

Yes I did the new combo box to select member and it then lists only for that member projects. It is the next page where it is not showing  ID for me to select only MemberName and other fields. The hide part comes after we select.  So I will check the Filter Records link that you shared.

Wondering if you're not having trouble because of the two member fields. Didn't want to throw any coding at a beginner problem but try this just to see if that's the issue.

Take the Member_TBL out of the query all togethor.
Remove the MemberName alias that we made

Make a new MemberName with this code:

MemberName: DLOOKUP("Member","Member_TBL","Member_ID=" & Member)

If that gives you any problems, you may need to wrap your underscore fields in brackets

MemberName: DLOOKUP("Member","[Member_TBL]","[Member_ID]=" & Member)

Bring in MemberPymntID and Member into the query. Go to try to make a combo box then, bring in MemberPymntID and MemberName

That will find specific records, if you want all the records for that member, base the combo box on Member and MemberName

I did try the above as mentioned and when I run query it gives all members and I want all the records for one member. When I base the combo box on Member and MemberName it displays and I cannot make a selection under the Details the data  for all members is already displayed.

Do you still have the member field in there with the criteria?

I could not get it to work, so I got rid of the Lookup field for Members and created MemberN  ShortText in the Table. Now in the Form it displays all Members data, I added the combo box. Now I have 2 questions In the combo box it displays all occurrences of members multiple times where as there are on 14 members. When I select the Member it does not filter.