Autofilling Data from one cell to another

[dchipilot]

I have my pilot logbook on Access. I fly many different types of aircraft, and put the times in individual fields. I have a separate table with aircraft info, and a separate table for the times. In a form, I select the specific aircraft and enter the time in a Total Time field. I would like the form to lookup certain yes/no switches in my 'Aircraft' table, then forward that time i've entered to the appropriate fields in the form immediately depending on the aircraft i've selected. Can I do this?

 

[Karl K]

Try editing the field's AfterUpdate property, adding code. The code would look something like

Me![Field I want to update] = DLookup(field,domain,criteria)

The criteria will look something like "[Field] = " & Me![Field2]

If you need more clarification, ask! The Help menu can help you with this too, under DLookUp.