One Read Only Form for Display

[Guest]

Hopefully I can post my questions so they makes sense. I’m relatively new to
Access, so the answers may be obvious to long time users.

I designed a One to Many form with a little twist, it also has a One to One
relationship to display company information. There is a form in the upper
right hand corner [frmCompany] that displays the company information from the
Company_ID selected in the parent table. It works, however, there are some
problems such as how do I make the form READ ONLY and how will that impact
the original frmCompany?

Although the company portion of the form is for display purposes only, after
the user finishes entering data in the child table sub-form, the tab order
brings the user to the first field in frmCompany. I tried making some changes
to frmCompany to prevent inadvertent changes to company information, but I
noticed that change made data entry impossible in frmCompany where the user
enters company information.

That tells me I should use TWO different forms, one to enter/edit company
data and another one for display purposes only on the One to Many Form.

Questions
[1] How do I make frmCompany read only [display] on our One to Many form?
[2] Should I in fact use two different forms for tblCompanies? One form for
data entry and a totally different read only form that displays company
information on our One to Many form?
[3] How does the above impact our TAB Order on the One to Many form?

Thanks,
Robert

 

[Allan Murphy]

Robert

On the fields that display the Company information set the properties as
follows

1. In the Data tab of the properties Enabled is set to No and locked is set
to Yes

2. No

3 . As the field is not enabled it should have no effect on your tab order

 

[Guest]

Hello Allan:

Thanks for the feedback, however, I'm having some problems with one of your
suggestions. If I use the same form [frmCompany] for both data entry as a
stand alone to enter/edit data for new companies, and then if I also use it
on this One to Many form for display purposes, it appears as if any changes I
make on the One to Many form also apply to the stand alone form. It seems as
if I have to use two different forms. Besides, it's no big deal.

I'm definitely going to try your other suggestion.

Robert



On the fields that display the Company information set the properties as
follows

1. In the Data tab of the properties Enabled is set to No and locked is set
to Yes

2. No

3 . As the field is not enabled it should have no effect on your tab order