Method or data member not found when trying to filter a table in a subform. MS-Access

Question

I am trying to filter a list of production numbers based on the staff member who made them. I am using the StaffID in column 0 of a combobox to do this.

When I try to run the code, I get a compile error. Method or data member not found.

I am new at this and am pretty sure I am doing something stupid but I can not figure out what.

This is the code:

intStaffID = Me.cmbboxStaffName.Column(0)
        
Me.subfrmProductionRecord.Form.RecordSource = "SELECT * FROM tblProductionRecord WHERE StaffID = " & intStaffID

Gustav · Accepted Answer · 2025-05-08 10:36:59Z

0

You can do this with zero code if you use MasterLinkFields and ChildLinkFields properties of the subform control.

As masterfield use the Id from the combobox.

As childfield use the StaffID of subform control's recordsource.

Also, make sure the combobox is unbound.

answered May 8 at 10:36

Gustav

56.3k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Azamact May 8 at 12:51

I need to do it this way because I will need to use multiple comboboxs to apply all the filters I may need. I dont think I can do that with master and chilf fields

Gustav May 8 at 13:19

OK. Your error just tells, that a field or control is missing or misspelled.

Azamact May 8 at 22:33

checked that. I copy pasted the names to be sure the spelling was correct

Gustav May 9 at 5:39

Then something else is going on.

Azamact May 9 at 6:49

I figured it out. I changed the name of the subform in the navigation pane but not in the properties. Thanks for the help Gustav

Collectives™ on Stack Overflow

Method or data member not found when trying to filter a table in a subform. MS-Access

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related