Cannot create a new record in a field

[shutzy]

i am trying to have a continuous form where i have a combo filter to filter the records. i would like to be able to add records on this form but i keep getting an error

Field cannot be updated

runtime error 3348
cannot add record(s); join key of table 'tblOrdersItems' not in record set.

the table system for the relevant tables is a one to many.(parent / Child)

it seems to work beautifully. i have the unique id fields of both tables in the form. i have the foreign key of the parent that is bound to the child form.

when i create a new record the error message appears. when i click end. i can see that the id fields have been populated and they look as they should. i cant seem to grasp what join key is not present.

ive uploaded a dummy to show you

open frmDiaryNoneItems. there is a combo box in the header that you will need to toggle to show some records. try and create a new record and you will grasp what i mean.

thanks

 

[JHB]

Try the below code:

Private Sub OrderDate_Change()
Me.Recalc
Me.StartDate = Me.OrderDate
End Sub

 

[shutzy]

worked a treat. im sorry about the incomplete upload. ive only noticed when i tried the new code. ive uploaded a new version with your code in it. the next problem is when i select the item(meeting/Lunch).

any help on this please.

i did actually think that this was a no hoper. i came to this conclusion when i thought about going through the form wizzard. with the fields that i chose it wanted to either link the forms or put in a subform. that way i couldnt have the continuous form.

you have renewed my hope.

thank you

 

[JHB]

Try the attached datebase now.

 

[shutzy]

thank you. can i ask what i was missing from the form. was it some fields in the form query.

thank you for your help

 

[JHB]

Oh - I can't remember if all fields were in the query or not.
But the main fault was that the Control Source of the combo boxes were wrong.