Selecting/Updating information using command buttons

  • Thread starter Thread starter Sean Paul Smith
  • Start date Start date
S

Sean Paul Smith

I have a simple database that has an area for users to
store address information on a "SITE" form. This includes
the postcode/zip code, town/locality, and local governemt
name. From this form there is a command button that opens
a "Postcode Selector" form that contains the FULL list of
towns and corresponding postcodes etc. Is there a way that
a user can select a correct postcode from the "Postcode
Selector" form and this will update or insert relevant
information into the corresponding fields on the "SITE"
form?

cheers,
sps
 
Hi,


In the AfterUpdate event of the postal code selector, make a DLookup on it, to reach the
relevant information. You can also use the possibilities to use multiple columns of data, in
Access, for a combo box. Me.ComboBoxName.Column( i ) will return the i-th column (for the row
actually picked up), the column can be invisible (width =0 ), so the user didn't necessary have to
see it in the selection process.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top