Drawing a major blank - please help!   

I have created a very simple database to record phone calls that are made to 
our retail outlets. I have been tasked to add a field for the actual delivery 
time in relation to the phone call. I have my form set up as data entry, 
mainly to save me from myself.

What I need to be able to do is to be able to search through those form 
records, find the form I need, and modify it to include the actual delivery 
time. Right now, due to the need for expediency, I wrote a quick query where 
I can add this information, but I need to open and close the query to enter 
new data. It works, but it is tediously slow going. I know that there is an 
easier way to do this, but my overtaxed mind is missing it. Any help that you 
can offer would be greatly appreciated. Thanks.

date: Thu, 21 Aug 2008 15:43:00 -0700   author:   springschick

Re: Drawing a major blank - please help!   

well, if you wrote a query to find a specific record, you can use that
criteria to do a Find on the recordset of the form instead. you'll need an
unbound control on the form to enter the criteria, and then probably a
command button to call the Find code. does this point you in the right
direction, or am i misunderstanding the question?

hth


"springschick"  wrote in message
news:59B7D23E-14F4-4E9D-BFAA-6697A4117697@microsoft.com...
> I have created a very simple database to record phone calls that are made
to
> our retail outlets. I have been tasked to add a field for the actual
delivery
> time in relation to the phone call. I have my form set up as data entry,
> mainly to save me from myself.
>
> What I need to be able to do is to be able to search through those form
> records, find the form I need, and modify it to include the actual
delivery
> time. Right now, due to the need for expediency, I wrote a quick query
where
> I can add this information, but I need to open and close the query to
enter
> new data. It works, but it is tediously slow going. I know that there is
an
> easier way to do this, but my overtaxed mind is missing it. Any help that
you
> can offer would be greatly appreciated. Thanks.

date: Fri, 22 Aug 2008 02:08:27 GMT   author:   tina