Button to open form linked to previous subform

[vbaInet]

You are getting that error because the ChildID you select in frmScores form when opened via frmChild must match with what's on frmChild.

 

[YNWA]

But I dont have a ChildID in the scores form do I?

I'm lost here.

 

[vbaInet]

I thought I had replied to your query. Just had a look at the db again and I could see where the problem was and made some amendments. Didn't test it much though. Let me know how if that works for you.

 

[YNWA]

Cheers for your help mate.

Do I need a requery or something on the Scores form, as when I enter the data, it doesn't save to the scores table unless I click out of that field.

If I enter the parent score then click close, that score is not saved in the table. However if I enter the score then click back into the problem field, it saves it.

Also if I open scores form on a contact and then do not enter any info, the close button will not close the form, I need to right click on the task bar and select close that way.

But what you have done it great, I now have the scores linking to the contacts etc...

Just need to try get that submit button in to submit scores to a table and then create a table like section on the scores form so users can see previous entries.

Also PM me my normalization problem mate, would hate that to ruin what I have so far.

Cheers
Will

 

[vbaInet]

Cheers for your help mate.

Do I need a requery or something on the Scores form, as when I enter the data, it doesn't save to the scores table unless I click out of that field.

If I enter the parent score then click close, that score is not saved in the table. However if I enter the score then click back into the problem field, it saves it.

A new record is created as soon as you click New. An update process is done when you move away from the record (or move to another record, or close the form). That's the behaviour of Access' bound forms. If you want to boycott this then you should be thinking of unbound forms and a save button that utilises the sql INSERT/UPDATE statement. This is a 'different kettle of fish'.

Also if I open scores form on a contact and then do not enter any info, the close button will not close the form, I need to right click on the task bar and select close that way.

Sorted. Attached.

Just need to try get that submit button in to submit scores to a table and then create a table like section on the scores form so users can see previous entries.

Also you need to work on the Delete button.

Also PM me my normalization problem mate, would hate that to ruin what I have so far.

Explain table-by-table what they do and the reasoning behind your relationships. Also, the general idea of what the database is for. How do you find out the scores a child has got? There's no "direct" relationship between tblScores and tblChild.

 

[YNWA]

A new record is created as soon as you click New. An update process is done when you move away from the record (or move to another record, or close the form). That's the behaviour of Access' bound forms. If you want to boycott this then you should be thinking of unbound forms and a save button that utilises the sql INSERT/UPDATE statement. This is a 'different kettle of fish'.


Sorted. Attached.

Also you need to work on the Delete button.

Explain table-by-table what they do and the reasoning behind your relationships. Also, the general idea of what the database is for. How do you find out the scores a child has got? There's no "direct" relationship between tblScores and tblChild.

Table by table as follows....

tblChild holds all child info name, age etc...

tblRefer holds all referral information eg. date, referID etc...

tblContacts holds each contact a child has per referral, such as contact date etc...

tblScores holds each score submission a child makes relating to a specific contact.

1 child has many referrals
1 referral has many contacts
1 contact has many scores

tblChild ID linked to childID in referral table, so each referral links back to 1 child.

tblrefer ID linked to referID in contact table, so each contact links back to 1 referral.

tblcontacts ID linked to contactID in scores table, so each score links back to 1 contact.

Then through those links, you can find out which score relates to which child etc... using a query?

Is that not correct?