Forms for data entry and viewing

[ceh]

Hello all, I would really appreciated some help on this.

I am new to Access (and databases from a creation point of view generally) and am having a problem with my main form.

This main form operates on sites and contains sub forms for data entry based on themes e.g. environmental, river details etc.. (these are contained in tables linked to the main site table through the site id - each has it's own primary key). The subforms are individual tabs within the main form. One of these is a survey subform.

The survey subform is slightly different from the rest of the subforms as there are only ten surveys that have been conducted for many sites (but the sites dont yet all have survey data against them). So I have a table in between the two that links survey id and site id. Inserting the survey subform works great until you get to a site that has no survey data entered yet.

As there is no record of a survey against the site the subform is returned as blank (no text boxes or anything).

However, I wish people to be able to use the form to capture survey information for that site (to be written into the survey table) and obviously they will not be able to enter data unless they are able to see the form contents.

What I would like is for the form to return all the text boxes etc as blanks that can be filled in.

I'm pretty sure that this is relatively straight forward and there is something I am just not getting - any advice would be very much appreciated.

Thank you.

 

[KenReay]

Hi

In the Survey SubForm, you do have teh AllowAdditions set to true don't you?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ceh]

Hi Ken

Thanks very much for the response - yep I have - alas.

I have also said yes to allow edits.

I'm pretty stumped at this point - I really think it has something to do either with the relationship or that there are simply no records in the survey table for a particular site.

if you have any more suggestions it would be wonderful to hear them.

 

[ceh]

I have sorted the problem out - there was a problem with how I had set up my relationships between the underlying tables. Establishing the correct parent-child relationships with referential integrity sorted it.

Thanks Ken for your help.