access vba courses

access vba courses - Subforms

Resolved · Low Priority · Version Standard

Subforms

Peter has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Peter [2 posts] (2007 Sep 13 Thu, 10:28) Reply

I've created a form with just a customer name as a combo box. I then created a subform related to the customer orders.

On opening the screen i can add new order data for the first customer but when i select another customer and try add new order information I get the error that i'm trying to add duplicate data before i even type in the order information. Any idea what i'm doing wrong?

Is a subform only for browsing?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Subforms

by - trainer David gold contributer [428 posts] (2007 Sep 13 Thu, 14:46) Reply

Hi Peter

You should be able to input data within the subform. I suggest you go over the SQL that you are using for you queries just to make sure that there are no errors in it.

Hopw this helps
David