By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

purchase order db

P: n/a
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


Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
Unfortunately no - our suppliers are wide and varied...


"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.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


Nov 12 '05 #3

P: n/a
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!txtSupplierName = "Microsoft"
Me!txtAddress = "1 Microsoft Way, Seattle, Washington"
... etc.
End Sub
Nov 12 '05 #4

P: n/a
Cheers.

"Trev@Work" <no.email@please> wrote in message
news:3f***********************@news.easynet.co.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!txtSupplierName = "Microsoft"
Me!txtAddress = "1 Microsoft Way, Seattle, Washington"
... etc.
End Sub

Nov 12 '05 #5

P: n/a
"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.Column(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
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.