Find and copy over data in certain fields - FORM (1 Viewer)

[ct2013]

Hi,

I have a database i use regularly and think i have a poor design for what i want to do next but need to work out the best way to make it work in its current setup.

I have a table recording enquiries which asks lots of information such as name, phone number, pets, date looking to book...

I want the table to search after the mobile number has been put in and automatically copy certain fields such as name, pets etc from the latest matching mobile number coming up into the new record to save us taking all the basic details which likely wouldn't have changed and then we can just fill in the missing fields manually as we take the enquiries.

I have thought about append queries or runcommand acCmdCopy but cant really figure out if what I'm trying to do is possible these ways or if it needs its own VBA script and someone may have a similar project i can see to work it out.

Many thanks in advance!

 

[theDBguy]

Yeah, that should be possible, but will probably need some code.

 

[ct2013]

Thanks. Any hints or examples of similar scenarios that can help me?
Cheers

 

[theDBguy]

Thanks. Any hints or examples of similar scenarios that can help me?
Cheers

Here's one example, but you might also want to read the whole thread.

Solved - Duplicate the record and let user edit it in popup form

Hi Folks, I have continuous form which shows the result of the measurements made by technician. You can add measuremnt by clicking Add Measurement, then Pop up form appears to input data. I want to add possibility to that user will duplicate selected record and further edit/adjust it in the same...

www.access-programmers.co.uk