S
steve
I have created a form with three combo fields:
Group
Org
Item
I want to use the data that is selected from these combo
boxes as the source for these three fields:
Field A
Field B
Field C
I am having trouble getting these three fields from either
my table, which has the six fields (Group, Org, Item,
Field A, Field B, Field C), or my query that is set-up to
QBF based on the data in the combo boxes.
For my output, I'd like the following functionality:
1. If a different Group, Org, or Item is selected from the
combo boxes, I want Field A, Field B, and Field C to
automatically update.
2. I want the data that shows in the Field A, B, C to be
read only and not able to be changed.
I think I need a Me.Requery in my AfterUpdate fields of
the Group/Org/Item combo box but I cannot seem to get this
to work.
Group
Org
Item
I want to use the data that is selected from these combo
boxes as the source for these three fields:
Field A
Field B
Field C
I am having trouble getting these three fields from either
my table, which has the six fields (Group, Org, Item,
Field A, Field B, Field C), or my query that is set-up to
QBF based on the data in the combo boxes.
For my output, I'd like the following functionality:
1. If a different Group, Org, or Item is selected from the
combo boxes, I want Field A, Field B, and Field C to
automatically update.
2. I want the data that shows in the Field A, B, C to be
read only and not able to be changed.
I think I need a Me.Requery in my AfterUpdate fields of
the Group/Org/Item combo box but I cannot seem to get this
to work.