Random Record Duplicate appearing from Table to Form?

[djspod]

Sorry I did not get what you meant by manually type into Property sheet?

Can you explain further please.



Whilst trying things out, I added the Sunday field from Rota Table to the main form, changed to combo box, set a query to TblSundays Date fields.

That seems to work but would you mind checking as it is not following your way of doing it, is this gonna cause me problems later down the line?

[aytee111]

Open form design mode, click on subform, open property sheet, type in main form field name in Link Master Fields property, subform field name in Link Child Fields property.

[aytee111]

I don't know why you didn't do what I said, now it is back to post #1.

[djspod]

Sorry aytee, I misunderstood and yes you are correct the same issue as occurred (IEost #1)

I have now completed your instructions and that has worked!

Sorry to took a while to get there, I'm still learning as I go.

Thanks for taking the time to help.



Attachment 27665Attachment 27666

[aytee111]

You're welcome!