Update Form Fields

[billgyrotech1]

Hello,

I have 6 fields on my AFRs form that have Name? in them. I removed the fields from the AFRs table but I would like them to reference the ID fields and put the text on the form.

Is there a way to do this without having to start over building the AFRs Form?

Thank you very much

[June7]

The data comes from 6 tables?

Why aren't you using comboboxes to select values?


Strongly advise not to use spaces nor punctuation/special characters in naming convention.

[billgyrotech1]

I started with combo boxes but after removing the fields like in one case:

Clerk and just left the field ClerkID

[June7]

And that is appropriate. Set comboboxes as multi-column. Display text description but save ID. Example for Customer:

RowSource: SELECT ID, Customer FROM Customers;
ColumnCount: 2
ColumnWidths: 0";1"
BoundColumn: 1
ControlSource: CustomerID

[billgyrotech1]

I tried it with the Clerk field. I would like it to be filled from the AFRs table data please. It should reference the AFRs table for a previous record and put the Clerk name in the field.

At least that is what I would like it to do please.

Thank you

[June7]

I don't understand. Then why do you have these 6 lookup tables?

Which previous record?

Perhaps you just need to set ControlSource property of each combobox to respective ID field from AFR table.

[billgyrotech1]

Yes that sounds reasonable. Can you show me how to do one of them so I can do the others please?

[June7]

I already provided property settings in post 4 for Customer.

[billgyrotech1]

Sorry but it does not populate the customer name that is from the AFRs table for AFR Number 85634

[June7]

That would be Richard Waters? Definitely shows for me. Review post 4 again. Are you sure you set all the properties as described?

[billgyrotech1]

I think so ?

[June7]

You have not changed ControlSource property for either combobox nor any of the other properties for Customer combobox.

[billgyrotech1]

Okay I changed the control source for the Customer field. It shows 831 which is the Customer ID.

Can it show the name?

Sorry I made the edit from your earlier post.

It works.

I will get to the others in the morning.

Thank you so much