auto populate based on three entries

[gbmarlysis]

Hi,

I would like to put a date in a form the region and then a staff code and based on the three entries then auto populate the remaining cells if those three have been entered together previously. Is this possible?
Regards


Luke

[June7]

Certainly, with enough code. The question is why? This appears to be duplication of data.

[gbmarlysis]

Hi,

Just the way I want it to run. I have certain data I want to enter if date, region and staff code are a certain combination. I would like to enter date, region and then staff code and if the three of them have been entered together before all the additional info I want to add to that combo will come up to show it has been entered already.

Regards
Luke

[June7]

What it really sounds like you want to do is check if the data combination already exists and if it does, go to that existing record. If it doesn't, then allow data entry for new record.

One way to do this is to set the 3 fields in table as compound index - then Access won't allow duplicate entries and will notify user if they attempt to save record. However, if you want to catch this before user goes through all the data entry work, will need code.

Code to look for existing data is fairly simple. The real trick is figuring out what event(s) to put the code into. Probably in the BeforeUpdate event of all 3 controls.