Link fields

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

Hi. I use Access 97 to keep track of my checkbook register and bank
balance. I have certain names set up to auto-complete in the Payee
field. For example, as soon as I type 'f', Access adds 'FirstCard'.

Certain payees get the same amount every month. How can I link the payee
and the amount? What is the coding?

Thanks!!!
 
Erika said:
Hi. I use Access 97 to keep track of my checkbook register and bank
balance. I have certain names set up to auto-complete in the Payee
field. For example, as soon as I type 'f', Access adds 'FirstCard'.

Certain payees get the same amount every month. How can I link the payee
and the amount? What is the coding?
Click to expand...

If you use a combobox with AutoExpand, you'll get your auto-complete
feature, and be able to add more columns. The Access combobox can have
multiple columns, so you can use that in your rowsource for the combo and
take the value in the additional column and push it into the amount textbox
in the after update event. Column counts are zero (0) based. Here's some
aircode:

Sub MyCombo_AfterUpdate()

Me.txtAmount = Me.MyCombo.Column(1)

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin said:
If you use a combobox with AutoExpand, you'll get your auto-complete
feature, and be able to add more columns. The Access combobox can have
multiple columns, so you can use that in your rowsource for the combo and
take the value in the additional column and push it into the amount textbox
in the after update event. Column counts are zero (0) based. Here's some
aircode:

Sub MyCombo_AfterUpdate()

Me.txtAmount = Me.MyCombo.Column(1)

End Sub
Click to expand...

Thanks, Arvin. I found the Lookup Wizard and added the 2 columns. Where
do I actually add the code? Thanks for your help - I'm really a beginner
at this coding stuff.
 
Back
Top