Recordsets, referencing tables and correlating data

lemon_balm

Registered User.
Local time
Today, 01:00
Joined
Feb 7, 2006
Messages
65
Hi all

I am trying to filter one of my tables from code to match up with a reference on my opening form. This reference is a building code. Basically I want to select the building I work in and have the tables filter for those specific results. I then need to use this reference in any new records I add so that they will appear next time I am at the opening screen.
Does anyone have any ideas?
I have used code to format the opening screen depending on this reference number and can output the reference but I cannot seem to store it within a record.

Regards

Jason
 

Users who are viewing this thread

Back
Top Bottom