Re: New Record Update

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 15:32:36 -0500

Ok, I'm having trouble following you, so I need the following answered
explicitly.

1) What is the name of the table that the data should be in?

2) What is the name of each field that the data should be in?

3) What is the name of the form?

4) If the form is a subform, what is the name of its parent form?

5) If the form is a subform, what is the name of the subform control on the
parent form?

6) What type of control is each of the fields bound to?

7) What is the name of each of these controls?

8) If the control(s) is a combo box
    a) What is its Control Source?
    b) What is its Row Source Type?
    c) What is its Row Source? If a query, paste in the SQL of the query.
    d) What is its Bound Column?
    e) What is its Column Count?

9) What is the form's Record Source? If a query, paste in the SQL of the
query.

10) What is the data type of each field (from the main table and the one
supplying the Row Source of the combo box). 

-- 
Wayne Morgan
MS Access MVP
"Michelle" <anonymous@discussions.microsoft.com> wrote in message 
news:108301c4bb4f$ea52c540$a601280a@phx.gbl...
> Good Morning Wayne,
>
> I have saved it and close the form and view my reports, it
> is still remaining the same. (No data showing).  However,
> my two fields that are autofilling have this:  =
> [UIC].Column(1) and [UIC].Column(2)in the control source
> area.  My first field (the one with the ComboBox) is bound
> to UIC, but not the 2 other one.
>
> I have to explain that when I started designing the form
> at the begining, the field called UIC and the 2 other ones
> were plain text, which means that I had to write them
> down.  After reviewing it and thinking about it I decided
> to put an autofill section to make it easier for a data
> entry clerk.  However, it is since I have made that change
> that everytime I add a new record and choose a new option
> (from UIC), it doesn't show up anywhere besides my form.
>
> Thank you for taking the time to help me on this.  I am
> scheduled to handover pretty soon this database to a new
> employee, but with this problem I am afraid that the new
> employee won't be able to give out the proper information
> in reports.
>
> Merci encore de ton aide
>
> Michelle
>>-----Original Message-----
>>Ok, assuming that the form and controls are bound to the
> table, then making
>>a selection and saving the record should write to the
> table. To save the
>>record you have to either explicitly save it or move off
> of that record to
>>another record and Access will automatically save it. Are
> you making the
>>selections then immediately opening the report? If you
> close the form and
>>reopen it does the new entry show up?
>>
>>-- 
>>Wayne Morgan
>>MS Access MVP
>>
>>
>><anonymous@discussions.microsoft.com> wrote in message
>>news:0f0e01c4babc$f3f934f0$a501280a@phx.gbl...
>>> Allo Wayne,
>>> First you need to excuse me for I am french and
> sometimes
>>> I do not express myself well.  Anyhow, I have set my
>>> autofill fields in my form (first).  I have a field
> with a
>>> combobox that allow me to choose an account.  Once I
> pick
>>> the account, I have two other fields that automatically
>>> filled with the name and location.  Now it is working
>>> wonderfully, the problem is that when I enter a new
> record
>>> and choose a new account, it does not show up in my
> table
>>> therefore neither in my report.  Because I have learn
>>> everything by myself (and I am really not too bad for a
>>> rookie), I have maybe forgot some things.  I have set
> the
>>> account field in my table to lookup wizard and the 2
> other
>>> ones to text.  Now eventhough I go back and drop them in
>>> my form, it is still not working.
>>>
>>> I really hope you can understand what I am explaining.
> I
>>> have this problem since awhile now and I am trying very
>>> hard to resolve it on my own, but I am afraid I need
>>> someone with greater experience.
>>>
>>> Thank you for all your help again.
>>>
>>> Michelle
>>>
>>>>-----Original Message-----
>>>>Michelle,
>>>>
>>>>If by "Auto Fill" you mean "Default Value", you are
>>> correct. Setting a
>>>>Default Value will not make the record "dirty". You have
>>> to change at least
>>>>one field manually to make the record dirty so that
>>> Access will save it.
>>>>Another option would be a Save Record button in which
> you
>>> use code to make
>>>>the record dirty (Me.Dirty = True) then save the record.
>>>>
>>>>This assumes that this is a bound form (there is a
> Record
>>> Source defined for
>>>>the form).
>>>>
>>>>-- 
>>>>Wayne Morgan
>>>>MS Access MVP
>>>>
>>>>
>>>>"Michelle" <anonymous@discussions.microsoft.com> wrote
> in
>>> message
>>>>news:0d5001c4bab8$b11d9030$a601280a@phx.gbl...
>>>>> How do I update a table when I enter a new record.
>>>>> Everytime, I enter a new record with the autofill
>>>>> function.  Although, I can see it in my form, the new
>>>>> entry does not show in my table and reports.
>>>>
>>>>
>>>>.
>>>>
>>
>>
>>.
>>
Quantcast