PHV
Thanks for that, also does the trick nicely, and with a fraction of the lines of code :)
It's been too long since I've had to play around with all this stuff, so at most of my code is done in a logical fashion which also mean lots of un-necessary lines of code.
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 was dabbling earlier and managed to find the properties bit where you can Link Child / Master fields, but no matter what I've tried I always get the same message.
You can't link an Unbound Form.
I'm not sure where I've gone wrong or what is required to make the Form Bound.
It's been a real long time since I learnt how to use Access, so I'm just piecing things together as I go.
It's just meant to be a really simple DB, there's only two normal tables and one lookup table, and a User Access Table.
All of the Tabs I am using have a sub-form in them, the Master Child...
Barbola,
You can try this, as I am also using tab pages, and have mine set so that a value from one Tab enters it itnto another.
now my coding skills aren't great so there might be an easier way but try this:
Dim Name As String
If Me!TabCtl0 = 2 Then...
I have a Main form I've called MainMenu, and then Stuck a TabCtl in it.
So basically I have one form which currently has about 6 tabs, form which I was going to do everthing. Most things I now have working, so I've got a nice login tab, and 2x Data Entry tabs, where the Worker.ID is linked to...
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...
Redwoodly, thanks for that it makes perfect sense.
I'm not back at that site until Monday so I'll give it a bash.
If it works I'll be giving you a big Man hug (a kiss is out of the question) :)
Andy
Thanks for the response, and you'll have to bear with me here.
My programming skills have well and truly lapsed, and so although I can read things written and work out how they work, developing things from scratch is proving to be quite hard.
I don't really have any code to post, as I'm...
I found this in my recent searches for help with Access, I think it does waht you are asking, one Independant Combo Box, and one that Depends on the other.
http://www.blueclaw-db.com/download/dependent_combo_box.htm
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.