Why unable to select new names for new record?

captgnvr

EAGER LEARNER
Local time
Tomorrow, 04:27
Joined
Apr 27, 2010
Messages
144
D/Sirs

I got the three tables 1. crew details; 2. store items details and 3. crew sales tables which has saleid, name_code, item_code etc.

The above I got something constructed on the lines of 'orders entry' for the crew who purchase stores.

I am able to see the various sales for each record (names in main form and list of purchases in subform using saleid as filter).

Even the command button to go to new record also works.

The place I am stuck is I am unable to select the new name from the combo box though it shows all the names. I tried the combo box as unbound also and checked if it is enabled or not also.

If I can get through with this it will be a big leap for enterin new purchases and/or to see records.

So earnestly request for quick help as to why I am unable to select new crew name to enter new purchases. I will keep watching for help - sacrificing even the world cup football :).

brgds/captgnvr
 
Check to see -

That the combo box's locked property isn't set to yes.
 
D/BOB
I Was only checking for enabled. Now I am able to enter after changing the combo box locked as 'no'. It is my own trouble. In one visual basic module, I have locked it on opening the form. It only struck after ur suggestion. Thanks. Let me start to enter and create records etc. "SAVIOUR"
 
Glad Bob got this sorted for you! FYI, another common reason for this happening is that the form's AllowEdits Property is set to No/False.
 
D/Missinglinq
Thank you. Will keep this in mind. I was in control room to try out the program and bit disheartened. It worked fine from cabin. When I tried from control room comp, getting many errors like 'activex component cant create object'; 'ole is not registered'; 'cant create dao objects'. So again I am trying to read up to solve this. Btw, our company still using office97.
 

Users who are viewing this thread

Back
Top Bottom