Re: Auto populate a form from an open form

Farmer,
Please... don't delete the previous posts from the "thread." It's helpful to see the
"flow" of the problem determination. Just let the posts "chain."

Well, I'm losing you on this... I can not figure out what you're trying to accomplish,
that a normal Client Main form, and One to Many realtionship with a Calls subform won't
do. There also may be some "language" or "terminology" problems that are causing my
confusion.
You should (at least) get the application to work in the most basic manner... and
then... if you must... expirement with some more complicated solution.

I can only suggest how I would do it...

When a client calls, you find the correct client record (Main), and add a new record to
the Call (subform).
Because Client records (ClientID-Autonumber) are related (one to many/refrential
integrity/cascades) to Calls (ClientID-Long), and are linked on the form via Master/Child
fields...
whenever you add a new call record, the ClientID in Calls is automatically updated to the
related ClientID.
CallStart should have a Default Value of Now()... (which you can change if needed)
so... you just have fill in the "other" call info (Subject, CallEnd, etc..)
CallStart should be Indexed, but "Allow Duplicates" should be true. If not set that
way, you won't be able to enter 2 calls with the same CallStart.

You appear to say that when you create a new call record (say... 3/11/07 @ 9:00am),
something creates another record with that same date and time??
That must be something you coded in, and I can't respond to that without more detailed
information on your code.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

"far-mer via AccessMonster.com" <u32423@uwe> wrote in message news:6f1d5a1608e80@xxxxxx
Al

Yes my main form consists of a tabbed page, however, (having played with this
most of the night) because I'm using a Now() for the time the call was taken
so that when the user logs the phone call it is given a time stamp - access
then creates the next entry below with the same time stamp, which causes a
problem when you have to make two entries as the old time stamp remains.

I managed to transfer the recordID from the form where the command button was
located on to the call record form by the following:

Default value [Forms]![New input screen]![Job Number]

I'm now trying an unbound form to stop the second record appearing below with
a time stamp.

Thanks for your response

Chris

--
Message posted via http://www.accessmonster.com



.