Help with sub-forms

  • Thread starter Thread starter Simon Harris
  • Start date Start date
S

Simon Harris

Hi All,

I have a form, containing a sub-form. Main form is jobs, sub-form is parts
ordered for the given job. The link field is ID on the main form, and
job_ref on the subform.

When I try to enter data in the sub-form, my computer pings at me (Default
wav noise) on my date field, when i select a supplier (combo) I get this
popup:

'Field cannot be updated' (Twice) Then...

'Cannot add record(s); join key of table 'TBL_supplier_orders' not in
recordset.'

What have I done wrong? I added the sub-form using the wizard.

Regards,

Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
 
Hi,

Thanks for the reply. Think I solved it - Subform was based upon an
non-updateable query, changed to use the table direct - AOK now.

Simon.
 
Back
Top