Update being done within subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stickandrock - 27 Dec 2004 00:51 GMT

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

Reply to this Message

smk23 - 27 Dec 2004 01:33 GMT

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 a main form that selects through a combo box a description column.
>
[quoted text clipped - 12 lines]
>
> Thanks for any input.....

Reply to this Message

stickandrock - 27 Dec 2004 01:39 GMT

I have possible mutiple rows for the same description... That why I was
looking to do it with a main and subform

> StickAndRock:
> It sounds like your basic design is flawed. The combobox needs to be unbound
[quoted text clipped - 24 lines]
> >
> > Thanks for any input.....

Reply to this Message

smk23 - 27 Dec 2004 01:43 GMT

Then you are correct. Just unbind your combobox and you should be in
business. Post back if not.
Sam

> I have possible mutiple rows for the same description... That why I was
> looking to do it with a main and subform
[quoted text clipped - 27 lines]
> > >
> > > Thanks for any input.....

Reply to this Message

stickandrock - 27 Dec 2004 01:49 GMT

not sure what you mean by unbind...

Kinda back where I started...

> Then you are correct. Just unbind your combobox and you should be in
> business. Post back if not.
[quoted text clipped - 31 lines]
> > > >
> > > > Thanks for any input.....

Reply to this Message

Duane Hookom - 27 Dec 2004 02:02 GMT

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?

Signature

Duane Hookom
MS Access MVP

>I have a main form that selects through a combo box a description column.
>
[quoted text clipped - 13 lines]
>
> Thanks for any input.....

Reply to this Message

stickandrock - 27 Dec 2004 02:23 GMT

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.

> 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?
[quoted text clipped - 16 lines]
> >
> > Thanks for any input.....

Reply to this Message