Subform Viewing

[austinr]

I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information.

Ideally, I would like them to display information when the field linked to the subform is entered on the main form. Is there an option for this ?

Any help is appreciated. Thanks.

 

[ansentry]

If I understand your question, you have the Main form set to "Data entry".

Therefore when you open the Main form it would be blank, and at a new record, so there would be no data in the subform to display.

Or am I missing something.

 

[austinr]

Yes, I have it set to data entry and I realize that it will not show any information. I would like the those entering data to not be able to change other records; however, I would like the subform to display information that corresponds to information that the data entry person may be entering.

For example: If the data entry person were entering information for a certain part with an ID number. When the data entry person entered the ID number, the subform would display the location information for that part number. This will act as a check for the data entry person.

Is this possible to do in access? Is the data entry function proper? Any help is appreciated.

 

[austinr]

Well, I've found a solution to the issue that I was having. Apparently, if you have a combo box on the main form, the subform does not communicate with it to display information. However, if you hide the field somewhere on the form, the combo box will communicate with both the field and the subform.