Recent content by Himy

OK so I'm new to a lot of this but here goes.. I have a database - it has over 1200 records with 35 fields in each record. Once I have finished adding in all the data - I want to be able to use the form I've created to enter the data, as a lookup form, for people to have in front of them - by...

I'm trying to run the simple NotInList example provided in the Access2000 help file. The Code is as follows: Private Sub Colors_NotInList(NewData As String, Response As Integer) Dim ctl As Control ' Return Control object that points to combo box. Set ctl = Me!Colors '...

I wish to assign an if the else procedure to a combo box - I then want to do a similar one to another, but with different variables. Each time I go to assign code it always refers back to the same code, and if I change the code for one - it changes it for all of them - so do I need to create...

OK I fixed it, and just for anyone else who has the same problem, it worked when I changed the BeforeUpdate event procedure name to =[Form_Current] instead of =Form_Current() Cheers, Himy

Hi David thanks for that, although it doesn't work still!! here's what I have, if I can explain in a little more detail... The error message I'm getting is this: The code I am assigning is this - it seems to check out no probs and is almost identical to 3 or 4 other codes people have shown...

I have a data entry form, with 30 odd fields in it. One of the fields has a combo box with three available selections. Depending on the Selection in this combo box - I want to "Enable" two other combo boxes for addition information. These are set to disabled as default... All information is to...