Update record form

[Stika]

Hi,

Im having all kinds of troubles with this form...

I have a table:
ID
Name
Street


Suburb
State
Postcode
Carrier
Freight

I've made a form that drags the record out by selection of a combobox(Name) But everytime I Select something it saves it as a new record and then when I Change something in it, It saves it as another record
My After_update code for the Combo Box
Private Sub Text17_AfterUpdate()
Me.Text19 = Me.Text17.Column(1)
Me.Text21 = Me.Text17.Column(2)
Me.Combo25 = Me.Text17.Column(3)
Me.Text27 = Me.Text17.Column(4)
Me.Combo29 = Me.Text17.Column(5)
Me.Combo15 = Me.Text17.Column(6)

I do have a query running...Ive attached a pic.


Im a little bit lost...any help would be appreciated

[June7]

Controls used as input for search criteria must be unbound (no ControlSource), otherwise you are editing record.

Why the code to populate controls?

[Stika]

Im not very good at this...im trying the best I can...if there is a better way to get the controls to show up that would be great

[Stika]

I Figured out how to do it thanks to this link you provided earlier in another thread

http://datapigtechnologies.com/flash...tomfilter.html

Thanks