Function is not updateable after filter is applied. - FORMS

[Duanw]

Hi Everybody

Had a really good reply from here before, maybe someone out there could help. I have a Access project connecting to the SQL backend. The form is based on a Function (Still wondering what the difference is Functions, SPs, Views...for a different thread.)

The Subform holds all Appointments for a specific Vehicle Registration in Datasheet view. When a user selects the Vehicle Registration from the main form, the subform is filtered, and only shows appointments relating to that vehicle. Problem is that the user cannot add any new appointments. Can only browse existing ones.

The function is simply a "SELECT * FROM tblAppointments", and should be updateable.

(Allow Edits, Allow Deletions etc. are all set to YES in the Forms Data Property sheet, and the Link Child and Link Master is set to blank, as it does nothing when they are linked)

Tearing my hair out on this one!! Anyone have any ideas?

Thanks

D

 

[mp9]

Because your link child and link master are blank, you can't add a record to the subform because Access doesn't know what value to put in the vehicle ID field in tblAppointments. You need to either code a means of populating the id field (by looking it up on the main form and copying it across) or better still set up link master/child properly so that this is done for you.