View Records on Form

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top