Button to update a field

  • Thread starter Thread starter green00guy
  • Start date Start date
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
 
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".
 
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
 
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".
 
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
Click to expand...

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.
 
Back
Top