Hello,
I have an access 2007 question that I thought would be easy, but I’m either making it much harder than neccessary, or it’s too complicated for me (I’m a bit of a novice).
I have a switchboard. There are 4 forms that you can open from the switchboard.
Customer
Orders
Inventory
Reports
The two forms Customer and Orders have several fields that I want to be linked (but are different tables), including RecordID, Customer, Phone.
When I open the Orders form from the switchboard, I want to automatically have Record ID, Customer, and Phone flood in from the Customer table.
Is there an easy way to do this? Have I explained it enough?
Am I way out of my depth? (oh wait, I can answer this one… yes!)
Quick and dirty way is to create a query getting all the fields that you want populated (use the query grid), then use the query as the data source for your form.
Thanks… I acutally just got it figured out using some code I cannabalized from an older simliar db. I was this close the first time, but was trying to pull from a field that didn’t exist (slightly different name)…