Form to Table Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form , which I would like to populate 2 fields in the table.
Is there any way that when entering in a form, to make it go to
2 different fields on the table. I have tried everything and my
Access book doesn't show anything like this.
Thanks for any help
Roger
 
A text box can be bound to only 1 field, but you could use its AfterUpdate
event procedure to assign the value to another field as well.
 
What value would I put in the AfterUpdate event, to get it to
do this. The Form, entry would be CharityName, and I
Also want it to go to AccountName.
Thanks for any Help
Roger
 
1. Set the AfterUpdate property of Charityname to:
[Event Procedure]

2. Click the Build button (...) beside this.
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, enter:
Me.AccountName = Me.CharityName
 
Thanks
That worked
Roger

Allen Browne said:
1. Set the AfterUpdate property of Charityname to:
[Event Procedure]

2. Click the Build button (...) beside this.
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, enter:
Me.AccountName = Me.CharityName

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

XeniaEagle said:
What value would I put in the AfterUpdate event, to get it to
do this. The Form, entry would be CharityName, and I
Also want it to go to AccountName.
Thanks for any Help
Roger
Click to expand...
Click to expand...
 
Back
Top