Recent content by BadScript

I figured it out, I tried: text1 = DLookup("[text1]", "Table Language", "[IDlanguage] = 1") And it worked :)

I'm trying to populate a textbox using DLookup. My textbox is called text1. I have a table called Table Language. I'm trying to get the value from the column text1 where IDlanguage = 1 The code I use: text1.Value = DLookup("[text1]", "Table Language", "[IDlanguage] = 1") I keep getting an...

I'm a beginner myself, but shouldn't you use the name of your control instead of the column name? Maybe you can add a print screen so it's more obvious what you're trying to do.. It's also a good idea to use 'else' in this case, what i mean is something like:

I got it to work now using the DLookup function: But I understand DLookup is slow, is there a better way to do this?

Oh yes, apology I see it now.. My form is not bound to any tables..

Tried to use the DLookup function lbl_chk1.Caption = DLookup("DGD", "tblReasons", "reasonID = 1") But must still be doing something wrong? :confused:

Thanks.. :)

I have a form with a couple of checkboxes, the labels of the checkboxes are named lbl_chk1 to lbl_chk10. I have a table that is called tblReasons, this table contains 2 columns: reasonID and DGD. I'd like my checkbox labels to display a value from this table, so I probably needs something like...

Thanks! ... Will try that tomorrow :D

true, i meant transparant, I'll try the empty conrol..

Thanks, you mean an invisible or empty control with a tabstop in the top of the header?

I have a form that's a bit too large for my monitor (I know, bad practise).. Whenever I tab through my controls it doesn't show the header anymore. Because of this a warning message in the header is not visible anymore. Is it possible to give a page up command with VB in the onfocus property...

I learned a bit more and your help was very much appreciated :)

Thanks :D Maybe it's just my form, I tried to bind it before and after closing the application it was no longer possible to access the data in the database. The data was there in the table but just not accessible through my form. That's when I decided to unbound it again.. Anyway, I got it...

I got it to work, thanks for the sample! I Finally finished my form and would like to thank everyone for their help, I doubt I would have been able to finish it without the people on this forum :D *thumbs up*