Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses - Subforms

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access vba courses - Subforms

Resolved · Low Priority · Version Standard

Reply Thu 13 Sep 2007, 10:28Delegate Peter said...

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

Subforms

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 13 Sep 2007, 14:46Trainer David said...

RE: Subforms

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

Access articles

· Microsoft Access Training Opens Doors
· How To Take Control Of Your Data And Save Money In The Process
· Why go on a Microsoft Access Training Course?
· How To Filter And Sort Data In Access 2010 Tables
· User-Proofing Your Access Database: Part 1

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips