Search results

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.

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...

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...

I solved this for anyone who is interested.... I just used: If cboLocation.ListIndex = -1 Then cboLocation = 11 .... And then I hid the combobox and it works perfectly.

Thanks Khodr - I appreciate your patience with me. I see what you are saying. Once I get the default value to display properly in the ComboBox I am not worried about hiding it with the Visible property - I've managed to do that much. But now we are getting back to the reason I posted this...

Form view.

Still having this problem. Any other ideas?

Here you go:

Ok, this time I no longer get the message box, but the combo box is still blank.

Thanks a lot! I set it up as you suggested, but now upon opening the form I am getting a message box "Enter Parameter Value" - Location.

Column Count = 2 Bound Column = 1 Row Source = tbl_Location "N/A" has Location_Id = 11 (column 1), Location = "N/A" (column 2) Sorry, hardwire might not be the right word. Obviously I'm not super experienced with MS Access. I just mean that I want to force it to set to N/A and not have the...

Thanks. But as I said, I've tried setting the default value every way I can think of. Of course the first thing I tried was the default value property. But everytime I open the form the ComboBox is still blank.

Alright - so I need to know if what I want to do is even possible or not. I have a form with a ComboBox. The ComboBox is populated with information from a table. Currently, we are not collecting the information for this ComboBox - so I want the default value of the ComboBox to be "N/A" (which...

Thanks jdraw, I have it written as you described, but am now getting an error for expected list separator or ). Any thoughts?

Hi, I am pretty new to VBA and am trying to do a lookup. I am getting a Runtime Error 13 Type Mismatch for the following line of code: Me.sf_LabelView!txtLabel.value = DLookup("[Label]", "[tbl_LabelsUsed]", "[Individual_Id] = '" & IndividualId & "'" And "[Use_Id] = 1" And "[Type] = 1") Am I...