Default value on continuous form from query

[p-rat]

I have a form that returns selected records via query. This is a
continuous form. I might have five records pulling in for example. In
the first record I have a combo box that pulls from query and
autofills several fields.

What I'm trying to do is that when this first records combo box is
selected I would like the remaining records default value for this
combo box to change to this value; which in turn will autofill the
other fields as well.

I am lost. Any help would be appreciated. Thanks.

 

[Marshall Barton]

I have a form that returns selected records via query. This is a
continuous form. I might have five records pulling in for example. In
the first record I have a combo box that pulls from query and
autofills several fields.

What I'm trying to do is that when this first records combo box is
selected I would like the remaining records default value for this
combo box to change to this value; which in turn will autofill the
other fields as well.

I am lost. Any help would be appreciated. Thanks.

Your question doesn't make sense to me. A DefaultValue is
only used on a new record so it would be irrelevant to
existing records.

Maybe you are only concerned with "auto populating" the
other records/ If so, I think you may be "auto populating"
the "first" record the wrong way or have some kind of
misunderstanding of something. Normally, the values from
the combo box's row source query are only displayed in other
text boxes by using expressions like:
=thecombobox.Column(N)
where N is the zero based number of the field in the row
source query.

 

[p-rat]

Yes, well I'm totally confused myself. I guess I'm trying to update
the existing records that I pull from a query. The background is that
we enter in tickets from a Job. There might be one ticket on a Job or
multiple tickets on a Job. Sometimes, unfortunately we don't know
where the Job is going to be taxable or non-taxable and when this
happens it is after the tickets have already been entered.

So in the case of when we have twenty tickets on a Job and there are
lets say 3 invoice line items on each ticket..... that means the user
would have to go back and Edit 60 rows of data.

On my query I show the 60 rows of data, but when changing the first
row tax fields (first field is combo box that when selected autofills
the two other tax fields in row); I would like all other rows tax
fields to default to the first rows values.
Can this be done?

Or is there a way to have a pop-up form that asks for Job Number and
the appropriate Tax fields. Once selected on the pop-up form it would
go in to the table and update these records?

Like I said, I'm lost. Thanks for any help.