Software

Ask something
Question Locked

Autofill in Access

0 helpful
3 replies

by svmecca

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a form and what I want to happen is when I enter a SSN (either in a text box or a combo box), a start date and an end date I want all the employees information to fill in the designated text boxes. The data is being written to a separate table but the fields wont update unless i close the form and reopen.

3 replies

by tony hopkinson

a post. Call post. save changes, update ... if you can,

move off the record and back on to it, is another way.

by sgt_shultz

Get the code builder by going to the form properities then on the after update event type Me.Owner.Requery

an example of what you are wanting to do is in the access sample forms. go to download.microsoft.com and search for 'sample form'

This discussion is closed to new replies.