Filling in text box from combo data

  • Thread starter Thread starter Arthur Banks
  • Start date Start date
A

Arthur Banks

Hi,

I'm very much a newbie with access and I'm trying to work on a database
for work use.

What I currently have is 2 databases, one which contains a list of all
the software we own, just for example:
photoshop 5
photoshop 6
photoshop 7
dreamweaver 2
dreamweaver 3
dreamweaver 4
office 97
office 2000
office xp

and the main database called inventory which lists what users we have,
what equipment they own and what software is on their machine.

Now in the Inventory database I have a seperate tab called Software and
I'd like to have a text box and a combo box.
The combo box I've managed to get as far as listing the fields in
software database but what I want to do is click on the combo, choose
an item, say photoshop 5 and when I click it, that item then gets
copied into the text box. Then I can click on the combo again and
choose another piece of software such as Office XP and so on.

The Inventory dbase has a field called software in it that the textbox
would save its data to so to record what software is installed on each
users machine.

Is it possible to do this at all?

Hope someone can help.

Arthur
 
Use the After Update event of the combo box to update the text box:

Me.MyTextBox = Me.MyComboBox
 
Back
Top