Autofill problem

[iamrah]

Hello friends,

I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box.

I have a table with the following fields:
PK - autonumber
Frequency - text
TimeD - text
TimeN - text

The frequency entry describes the frequency at which paramaters are to be measured, and Time1/Time2 are the times that are set by each frequency for Day and Night resp.

I know this has been discussed ad nauseam, but I have spent almost a week searching this forum as well as a couple of others, and just keep coming up short.

I have uploaded a zipped db that will better illustrate where I'm at with this project. Please have a look.

thanks in advance.

 

[ansentry]

Here is your sample back.

 

[iamrah]

Awesome, thank you John.

So, I didn't designate a source for the text, brilliant!

One more question if I may? What would be the easiest way to have the combo box display only the frequency (column 1) during selection, and simply have the text boxes fill appropriately?

Thanks again.

 

[iamrah]

Nevermind, I got it. Thanks again.