Required field in a form

[scottappleford]

Hi

Could someone please tell me the code to stop a user accessing a subform if there is not a related field in the main form.

I keep getting 'this field is required etc' then having to close the db before it will let me carry on.

Thanks

Scott

 

[WayneRyan]

Scott,

When you Design the forms, use the Master-Child relationship that
Access supports. Only the child records for any given parent are
available. Access will do all of the synchronization.

Wayne

 

[scottappleford]

Please explain

Thanks for the info - but how do i do that?

When i open the main form with the sub form attached - it still allows me to enter data into the subform if the main product record does not have a record.

I understand what you are saying but how do i make this happen?

Thanks