Find and copy over data in certain fields - FORM

ct2013

Registered User.
Local time
Today, 19:49
Joined
Jun 6, 2013
Messages
87
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!
 
Yeah, that should be possible, but will probably need some code.
 
Thanks. Any hints or examples of similar scenarios that can help me?
Cheers
 
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.
 

Users who are viewing this thread

Back
Top Bottom