Update being done within subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that selects through a combo box a description column.

I created a subform set up with master and child on this description field.

both the main and sub form are based on the same table.

When I select a description the subform works correctly, but the first row
of the table gets updated with the description selected in the main form
combo box.

Not sure why this update is happening.

FYi The first row of the table always gets updated with the last selected
value in the combo box of the main form

Thanks for any input.....
 
StickAndRock:
It sounds like your basic design is flawed. The combobox needs to be unbound
if you are intending only to select a record with it. Go to the ControlSource
property and delete the entry in that property. You could then put code on
the "On Update" event of the combobox to move to the selected record, in
which case you wouldn't need a subform to display the description.

If that is too much for right now, the subform containing the description
column will work if it is properly linked parent-child to the combobox value.
HTH
Sam
 
I have possible mutiple rows for the same description... That why I was
looking to do it with a main and subform
 
Then you are correct. Just unbind your combobox and you should be in
business. Post back if not.
Sam
 
You combo box must not have a Control Source property. Delete it. Are you
even sure you need to bind your main form to a record source?
 
Bingo..... Force of habit when creating a form , should have made it a
straight Combo box with a row source query.

Thanks for the input.
 
Back
Top