Find Record and fill form

[southboy]

I have a form I use to pay monthly bills. I had a findrecord combo box and a find next record button that worked before MS Access 2007. After I selected the bill I wanted to look at it would fill the form fields with that record and I could edit it. After I converted the DB to 2007 now I get an code error when I click on the findrecord combo box and it dosn't work.
I recreated the combo box using the find Record combo wizard and selecting the "Find a record on my form based on the value I selected in my combo box" But that does not fill the form with the record information I selected from the combo box. It does nothing. How do I get the combo box selection to fill the fields on the form with that record?

Thank you,
southboy

 

[TheAceMan1]

How are ya southboy . . .

Post the [blue]RowSource[/blue] and any code in the events of the combobox.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[southboy]

Thank you for the tip and I'm doing well, thanx for asking. I now can get the combo box to fill the form, but the combo box now list every instatnce of the record by date. How do I get just the last entry to show in the combo box and fill in the fields in the form as well?

Thank you!

 

[TheAceMan1]

southboy . . .

Post the code for the combobox!

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

southboy . . .

Is the form [blue]bound?[/blue] ... and I've asked twice to see the code for the combo.

[blue]How do I get just the last entry to show in the combo box ...[/blue]

Do you mean show in the textboxn portion of the combo?

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[southboy]

TheAceMan1 I appreciate your help with this.
The form is bound to a query that has all the fields from both tables in the database.

The combo box is unbound and yes I want only the latest record to show in the combo box.

The code is:
Private Sub Pick_Click()
Me.RecordsetClone.FindFirst "[Bills] = '" & Me![Pick] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
and the rowsource is
SELECT DISTINCTROW billsname.Bills, Bills.Month, Bills.[This Pay], Bills.[Confirmation #], billsname.Http, billsname.Autodraft, billsname.PhoneNumber, billsname.[Due Date], billsname.Increment, Bills.Notes, billsname.Autodraft

Southboy