I am building a database by entering order numbers and selecting othe
specifics through optionbuttons and checkboxes.

How can i reload this data in the main screen so the user can enter th
order number and the values in the optionsbuttons and checkboxes ar
automatically reloaded so the user can change them?

Thank

--
Redondo
-----------------------------------------------------------------------
Redondo7's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=39852

Read your data based on the key value provided by the user, then set the
state of each control according to the data values stored in the database.
There is no automatic procedure to do this.

--
Regards,
Tom Ogilvy

"Redondo7" wrote in
message ...

I am building a database by entering order numbers and selecting other
specifics through optionbuttons and checkboxes.

How can i reload this data in the main screen so the user can enter the
order number and the values in the optionsbuttons and checkboxes are
automatically reloaded so the user can change them?

Thanks


--
Redondo7
------------------------------------------------------------------------
Redondo7's Profile:
http://www.excelforum.com/member.php...o&userid=26577
View this thread: http://www.excelforum.com/showthread...hreadid=398523

I hope this isn't too simplistic a reply but short of actually coding
an example, here's a scheme.

1. Hopefully, your controls are contained within a form. If not, they
need to be.
2. The form would include an new control that activates a search
function macro.
3. If the search locates a match, copy the record and use its data to
alter the properties of the forms embedded controls.
4. You'll also need another control to save the changes. This function
has to address the database format and whether the old record is
replaced, or deleted and the changes saved as a new entry.
5. A message would inform the user of NO Matching Record when
appropriate.

regards,

mike