combo box and error message

  • Thread starter Thread starter Squibbly2
  • Start date Start date
S

Squibbly2

everytime i try update a field on a form using the combo box, it keeps
coming up with an error message:

Cannot update field

it sometimes saves the update and sometimes doesnt saying it cannot say the
update or something of that nature
can some1 please tell me where im going wrong. it works perfectly in the
other databases i have created
 
everytime i try update a field on a form using the combo box, it keeps
coming up with an error message:

Cannot update field

it sometimes saves the update and sometimes doesnt saying it cannot say the
update or something of that nature
can some1 please tell me where im going wrong. it works perfectly in the
other databases i have created
Click to expand...

We'll be glad to tell you what you're doing wrong... if you'll tell us
what you're doing. You can see your screen; we cannot!

Please post the following:

- the RowSource, Bound Column, and Control Source of the combo
- The datatypes and sizes of the bound column field in the combo's
rowsource, and of the Control Source field into which you're trying to
store the data
- The Form's Recordsource (post the SQL)
- Examples of the data which saves correctly, and of the data which
fails

John W. Vinson[MVP]
 
what i am doing is getting a name from a list in a different table which is
on the form, as i dont want to spend endless hours/mins typing in the
persons name then find errors
as you will gather i am using a combo box to resolve this laborious method
 
solved the problem by creating a new form i dunno why this works and the
other one didnt perhaps got corrupted??
 
solved the problem by creating a new form i dunno why this works and the
other one didnt perhaps got corrupted??
Click to expand...

Well, since you chose not to show us the necessary information, that's
as reasonable a guess as any.

John W. Vinson[MVP]
 
Squibbly2 said:
what i am doing is getting a name from a list in a different table which
is on the form, as i dont want to spend endless hours/mins typing in the
persons name then find errors
as you will gather i am using a combo box to resolve this laborious method
Click to expand...
 
Back
Top