Why can't I add a new record?

[loopa1]

I have a form 'frmCarerDetails' which a command button I've set to open a new form 'frmEpisodeDetails' on which the user should be able to add episode details for the carer which was being viewed on frmCarerDetails.

However, whenever frmEpisodeDetails opens, it doesn't allow me to enter any values - I can choose any of the text boxes and type, but no text appears nor does an error message. frmEpisodeDetails is based on a query - but if i change it so it's based on the main table in the query the form can be used to add new Episode Details.

The main table in the query is called 'CarerEpisodes' which has a many to one join to the 'Carers' table. My query is used to add all the fields from the table CarerEpisodes to frmEpisodeDetails so that they can be edited or populated with new info on a new record, plus it pulls the Carers' name from the table Carers.

If I base frmEpisodeDetails on the table 'CarerEpisodes', it allows me to add records no problem...so what have I done wrong in my query?

I'm guessing there's a relationship set incorrectly somewhere, but I have no idea what I've done wrong as I was certain this form/query was set up in a similar way to another form which accepts new records no problem...so I can't see what the problem is!

 

[loopa1]

Typical...been struggling with this for almost a day, and minutes after posting on here I try something in my database and manage to fix the problem.

I think I was using a join to another table incorrectly. I joined a table to CarerEpisodes to return the text value based upon the record's (autonumber) ID. But I removed the join, realised it had no impact upon my frmEpisodeDetails as this was set up to lookup the values in this other table anyway and choose the correct bound column etc. etc. and it's worked.

Finally!

 

[HiTechCoach]

Great job getting it figured out.

Thanks for posting your solution.