Microsoft Access: How do I show the name field that corresponds with an ID field in a form?

Question

I'm not sure how best to explain this. Basically I have a Class ID on a form, and I want to show the Class Name from that record in the Class table on a form that I'm filling out.
Someone with IM chat would be really helpful!

Answer 1

I think you may need to place the field on the report and then change it to Locked Yes or Enabled No, in that field's properties.

Locked allows you to think you can change it but won't let you. Enabled, No won't let you in the field, but displays it.

Open the for in Design mode, then do View Field List. Select and drag the field to the form where you want it. Move it, size it and do the fine tuning on the position on the form.
Right click on the field and choose properties. On the All tab or the Data tab, find Enabled or Locked and change the default of one of them depending on how you want it to behave on the form. Try both see what you like, just be sure to change the other back when you change one.

Good Luck.

Answer 2

If I understand correctly, you need to do 2 things:

1) Create a Class Name drowdown menu. Its query should be based on the data held in the Class ID object. Example: SELECT ClassName FROM Classes WHERE ClassID=[MyForm].[CID].value (sorry, but there might be a few mistakes in this query...)

2) Create a Class ID dropdown menu named CID with an action on "On Change". This action should refresh the Class Name object. Ex: [MyForm].[ClassName].refresh (once again, sorry if there are any syntax errors, but the concept is there)

Hope this helps.

Answer 3

you could configure the mixture field to purely exhibit the sphere or column values you opt for for to exhibit. think of of the question as an array(0,a million,2) opt for instructors.FirstName, instructors.LastName FROM instructors; in the combox discover the exhibit field fee and enter 2, then create the exhibit length of each and every column with 2"; 3: and then shop.