Combo Box Not finding Records on Form

[sivega]

I have a combo box on a form that is bound to a table. The combo box is supposed to find records and populate the other fields on the form for modification. This worked at one point but not anymore.



Could really use some help. Thanks!!

[rpeare]

if you're using your combo box as a search criteria it should be an unbound field, then requery your form in an appropriate place (i.e. in the ON EXIT property of the combo box). Just make sure the PK of the combo box matches the PK of the form you're doing data entry against.

[sivega]

I found the problem: The Data Entry property was set to Yes. When I set it to No, it started working again. I would prefer it to open to a record when the form is opened but it can't be done.....

Thank you!!

[Missinglinq]

...I would prefer it to open to a record when the form is opened but it can't be done...

If the above was supposed to say

"I would prefer it to open to a new record when the form is opened..."

which I presume was the reason for having Data Entry set to Yes, simply put this in you Form's Code Module:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
 End Sub

Linq ;0)>