purchase order db

[Lapchien]

I have a purchase order database, i use 1 particular supplier very often -
i'd like to put a button on my form which, when pressed, 'auto-filled'
several fields (like supplier name, address, telephone number, buyer, etc).
Is this easy enough to achieve?

Thanks,
Lap

[Phil Stanton]

I should have thought that you would have a table of suppliers and a srop
down box to select the supplier for each order. Presumably a FK in the
Orders table linking it to the supplier.

HTH
Phil
"Lapchien" <no**@m.com> wrote in message
news:10******** *******@ananke. eclipse.net.uk. ..

I have a purchase order database, i use 1 particular supplier very often -
i'd like to put a button on my form which, when pressed, 'auto-filled'
several fields (like supplier name, address, telephone number, buyer, etc). Is this easy enough to achieve?

Thanks,
Lap

[Lapchien]

Unfortunately no - our suppliers are wide and varied...


"Phil Stanton" <di********@sta ntonfamily.co.u k> wrote in message
news:3f******** *************** @mercury.nildra m.net...

I should have thought that you would have a table of suppliers and a srop
down box to select the supplier for each order. Presumably a FK in the
Orders table linking it to the supplier.

HTH
Phil
"Lapchien" <no**@m.com> wrote in message
news:10******** *******@ananke. eclipse.net.uk. ..

I have a purchase order database, i use 1 particular supplier very often - i'd like to put a button on my form which, when pressed, 'auto-filled'
several fields (like supplier name, address, telephone number, buyer,

etc).

Is this easy enough to achieve?

Thanks,
Lap

[Trev]

Lapchien wrote:

Unfortunately no - our suppliers are wide and varied...

That's not uncommon, however to do what you want in your circumstance
would be just a command button with the event procedure for onclick, e.g.

Sub cmdFavSupplier_ Click()
Me!txtSupplierN ame = "Microsoft"
Me!txtAddress = "1 Microsoft Way, Seattle, Washington"
... etc.
End Sub

[Lapchien]

Cheers.

"Trev@Work" <no.email@pleas e> wrote in message
news:3f******** *************** @news.easynet.c o.uk...

Lapchien wrote:

Unfortunately no - our suppliers are wide and varied...

That's not uncommon, however to do what you want in your circumstance
would be just a command button with the event procedure for onclick, e.g.

Sub cmdFavSupplier_ Click()
Me!txtSupplierN ame = "Microsoft"
Me!txtAddress = "1 Microsoft Way, Seattle, Washington"
... etc.
End Sub

[Pieter Linden]

"Lapchien" <no**@m.com> wrote in message news:<10******* ********@ananke .eclipse.net.uk >...

I have a purchase order database, i use 1 particular supplier very often -
i'd like to put a button on my form which, when pressed, 'auto-filled'
several fields (like supplier name, address, telephone number, buyer, etc).
Is this easy enough to achieve?

Thanks,
Lap

Lap,
one way to do it, and there are many, is to have a combobox on your
form where you choose the supplier/supplierID. you can hide all the
extra columns (set the width=0) and then use cboSupplier.Col umn(i) as
the controlsource for all your values you want to show (name, address,
tel#, buyer...) I like that because it's pretty quick and easy. All
covered in ADH, too.
HTH,
Pieter