Access Sub form issue

[djspod]

Hi All,


I have built a main form which has a Sub form linked to the main form.


All seems to work okay, However the user is able to select items in the Sub Form before the main form itself.


If this route is taken by the user when they select an item in the main form the following appears. (Please see screen shot)


I may have screwed a relationship or table up that is bound to the form?


Ideally I would prefer the sub form be locked until all the details above in the main form are filled in first.


Any ideas folks?


https://drive.google.com/file/d/0B6r...ew?usp=sharing


Username: darren godkin
Password: test
https://drive.google.com/file/d/0B6r...ew?usp=sharing


the form is the 'frmshortagesmain'

[ranman256]

You CANT add items to the subform until the master form has a key. (1-many)
Once the master key is created THEN you can add child records.
Marty McFly cant exist until George meets Lorraine.

[djspod]

Thanks for the answer, I thought that but ar the moment you are able to make a couple of entries in the sub form beforehand.

I want to limit the user from being able to do that and avoid that error

[ranman256]

Then remove the ability for users to add new master records. (form property)

[Missinglinq]

(Aircode/Untested)

You could, in Form Design View

• Right-Click on the Subform Control
• Click on Conditional Formatting
• Under Condition1, with the dropdown, select 'Expression Is'
• In the next box enter IsNull([Linking Field])
• Click on the Enable/Disable Icon to Disable it
• Click on OK

Where Linking Field is just that...the Field that links the Form to the Subform.

Linq ;0)>

[June7]

Linq, subform container control does not have Conditional Formatting. Wishful thinking guide your suggestion?

[djspod]

Thanks for your help everyone.

Just out at the moment, I'll have a look later at the suggestions.

Much appreciated, I'll feedback later.

Thanks