Form not saving record

[berg]

Hi,

I have a form used for data entry and saving records to a table. The user enters various data into text boxes and makes a few selection based on comboboxes. It works great, however if they select one particular option in the combobox it just doesn't save the record. The combobox is based on a lookup table and all the other options save properly. I see no reason why access should be treating this one option differently.

Has anyone encountered this issue before? Any advice on even where to start looking for the problem?

Thanks in advance!!

berg

 

[AccessMSSQL]

Is the combo box bound to a particular field or are you performing logic in VBA to save the record back to a table? I would check the field you are saving the combo box values to and make sure that the field type and size are correct for the value you are selecting. If that's not the issue, check the logic you have for saving a record?

 

[Sketchin]

Also check that your control source is correct

 

[berg]

The combobox is unbound, and I am saving the record using VBA. This is where the problem must be - but I don't know why it won't accept only one of the options out of the combobox.

It is not the longest record in the lookup list, and the other ones are saving fine, so I don't think it is the field type or size.

As for the control source, where would I check that? As mentioned, the combobox is unbound so it has no control source. Only a record source linking to the lookup table.

Very strange indeed.

 

[berg]

Found it! It was a coding problem. If that option was selected from the combobox there was a line of code missing telling it to save the record.