access+training+courses - returning order number form

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

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:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.08 secs.