access+training+courses - returning order number form
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+courses - Returning an order number on a form when a part number is entere

access+training+courses - Returning an order number on a form when a part number is entere

resolvedResolved · Low Priority · Version Standard

replyReply Tue 2 Oct 2007, 16:22Delegate Paul said...

Paul has attended:
Access Intermediate course
Access Advanced course

Returning an order number on a form when a part number is entere

Hi all,

I have a form whereby I want to create a default value in the order number box from the parts table.

What I want is when I enter the part number (from a drop down) into my form, the I want the order number, which is a field in it's own in my parts table.

Carlos helped me work out something similar to this on my course using a macro, but I can't work out how to do this.

Please help!

Thanks - Paul

For upcoming training course dates see: Pricing & availability

replyReply Thu 18 Oct 2007, 14:05Trainer David said...

RE: Returning an order number on a form when a part number is en

i suggest you contact the office to enrol on our access vba course

 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard