Button to update a field

G

green00guy

Can someone point me in the direction of a tutorial to do the following

I have a continuous form that allows me to choose the supplier for a product

product name | supplier 1 | supplier 2 | supplier 3 | supplier 4 | supplier
5 |
text box button button button button
button

There can only be one supplier, all updates will be done to the item
information table.

Currently I can do this with a combo box, but would prefer to do with with a
buttons.

Thanks
 
D

Dorian

The standard way to select one item among many is a combo box not buttons.
This is because if the number of selectable items changes, a combo box
automatically displays them all (by being based on a query), whereas your
buttons are fixed in number and inflexible.
I would strongly suggest you rethink your design.
-- Doprian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
G

green00guy

Dorian,
I agree with you, but from a usability standpoint buttons are what they are
telling me they want. We have a fixed population of suppliers.

Thanks
 
D

Dorian

It may be fixed now ... but wait...
It's only a metter of time before they come to you and say 'can you remove a
button?', or 'do you have room for 3 more buttons?'.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
J

John W. Vinson

Can someone point me in the direction of a tutorial to do the following

I have a continuous form that allows me to choose the supplier for a product

product name | supplier 1 | supplier 2 | supplier 3 | supplier 4 | supplier
5 |
text box button button button button
button

There can only be one supplier, all updates will be done to the item
information table.

Currently I can do this with a combo box, but would prefer to do with with a
buttons.

Thanks

I'd store the supplierID in a single field (not five fields... ouch!!!!) and
use an Option Group control with five radio buttons (arrayed horizontally if
you wish) to select one of them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top