Non Updateable Form Trouble

[sross81]

Hello,

I have a form that is driven from a query. The query just had one table and two of the fields were facility id and unit id stored as numbers with the actual descriptive value stored in a lookup table. My first thought was to link the Unit and Facility table in the query that was driving the form, but that made the form non updatable.

I need to show the actual values of facility and unit that are in the lookup tables on my form without adding any joins to the query because I need it to remain updateable.

Can anyone point me in the right direction?

Thank you.

 

[Beetle]

Use combo boxes on your form. Each combo box would return the key value and the descriptive value form the relevant lookup table and would be bound to the FacilityID and UnitID fields in the form's record source query

 

[sross81]

That is what I was thinking about doing, I just didn't want to give the user the perspective that they could or should change the value. I could just lock the field.

If there is any other way I would like to learn that too.

Thank you.

 

[Beetle]

You could use the DLookup domain function in the Control Source of text boxes on your form. Keep in mind that if this is a continuous form then that won't be a viable solution due to the nature of the way unbound controls work on continuous forms.

 

[sross81]

It is a single form. I didn't know about DLookup. I will look up how to use that function. Thank you!