Look Up Filter on Form with BackEnd Tables

[krabine]

Hello,

I'm fairly new to Access databasing but learning quickly.

I have a backend database that contains part number and molding unit they are made on and material, etc.

In the front end I have a form where you can create a record of a lab report needed to be made from the certain parts and pull info from these backend tables. \

In the form I want to enter the pin number (as unique as part number) and then filter to the molding units that they are created on (can be more than one).

Right now I just use a afterUpdate macro to populate the the molding unit on the form with

Please Login or Register  to view this content.

I can't figure out how to apply a filter look up.

[BattleCat]

Have you tried a DLookup? You can use it to filter what you want much like a where clause in a SQL statement.
https://support.office.microsoft.com...rs=en-US&ad=US
I'm not sure exactly what you are trying to filter.