Link fields

[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!!!

 

[Arvin Meyer]

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?

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

 

[Erika]

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

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.