Can someone possibly help with this.
I've done a bit of looking around and I can't find something that quite matches my problem.
This is the code I'm using;
Dim L As Recordset
Set L = Me.RecordsetClone
L.FindFirst "[tblStolen]![ID] = " & Me![Combo_Stolen_Lookup]
Me.Bookmark = L.Bookmark...
I have a Combo Box that is run from a simple query.
All it does is look up the Workers from tblWorkers and gives me a list of the names.
Currently I have it set so that the ComboBox records this value in on of my table fields, and I would also like to do is get it to record the ID value from...
I have a simple DB with three tables, two of them I have linked together, one for Workers and one for Equipment.
I've created a third table to record any equipment that gets stolen.
To try and keep things simple I want to take the ID from the Worker Table and Use it as the ID for the Stolen...
I'm having a complete mental block on why this isn't working.
I have two lookup tabs, in that they will be deisnged soley for looking up information and not changing.
I have managed to get it so that the Worker.ID is linked to the Equipment.ID (as they are the same) the only problem I now have...
I currently have a tab structure for a simple DB, and after a little bit of fiddling I've managed to get two of the tabs to link up in the way I want.
For example, the Main.ID is taken from Table 1 and then when Page2 (of the tab) is opened it passes the Main.ID into the Sub.ID field, allowing...
I'm in need of a little assistance if someone could possibly help me.
I'm trying to create a simple little db, using tabs.
I've already managed to piece together a nice little login facility, with access rigths. So that I can dispaly whih tabs I want depening on your access.
I'm now having a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.