Adding fields to a table that do not appear in a form

[Guest]

I am a newbie who is trying to create one large database to use as the basis
for several forms, in lieu of entering data in several Excel spreadsheets,
for a job placement firm. The idea is to use the large database to enter all
necessary information, and create forms for each scenario the company needs
(pending jobs, jobs in search stage, placed candidates, and closed jobs.) I
have successfully created tables to use for drop-down boxes in several fields
(internal employee names, job titles, reasons for delays at certain stages of
job placement). I have not based anything on queries or calculations. I
created test records, and the form looks fabulous. However, I now need to add
fields to the main table, and when I do that the new fields do not appear in
the design view of the form, so I cannot include the new information that we
need. Any light you can shine on my lack of knowledge would be greatly
appreciated. (FYI, I got the Access 2003 Bible from recommendations on this
site, and it has been a great resource.)

 

[Guest]

Very simple.
Open the form in design view.
Create a new control.
Open the Properties Dialog box.
Select the Data tab.
The first combo on the tab is Control Source.
either type in the name of the field or use the drop down to select it.

Then (and this is important)
Open your check book
Write a large check
Send it to Klatuu

 

[Guest]

Hmm. This is not working yet, but I'll give it another crack tomorrow. Until
then, Barada Nikto! I'll balance my checkbook and see what's left.

 

[Guest]

LOL, so what is not working?

Hmm. This is not working yet, but I'll give it another crack tomorrow. Until
then, Barada Nikto! I'll balance my checkbook and see what's left.

 

[Guest]

I'm not properly creating the control, and I need to fix the drop-down tables
so they appear correctly. When I go to the Data tab and try to type in the
field name, it switches away from the table that the form is bound to, and
gives me the yellow popup box with exclamation point (very ugly). I am
certain this is due to operator error. I think classes will take too long for
what the company wants, but reading books and hitting the help key is proving
time consuming. I have tried to find a tutor or consultant in the Kansas City
error to help me complete this dagnab thing before it drives me mad.

 

[Guest]

Then you are in the wrong place. When you open the properties dialog, you
need to be sure the control is the current object. The easiest way to do
this is to select the control, right click, then select properties from the
drop down.
It sounds like you are in the Form properties.

 

[Guest]

Do Americans "really" say -"Dagnab Thing" -thought that was just in the
cowboyfilms.

 

[Guest]

Only in films made prior to 1957 and only if Walter Brennon says it.

 

[Guest]

Did watch the new Miami Vice file and noone said it that, so you must be
right. I'll go there one day and have a look.

Mind you I do remember the old lady said it (think she was called
"Granmarrr"). It was her son who had the ferry in the Outlaw Josie Wells.
Maybe I'mjust old. Oh well.

--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.

 

[Guest]

Yeah, I forgot. Old Ladies in Westerns were allowed to say it. In fact, I
think it may have been a requirement.

 

[John Spencer]

Well, I do on occasion, but then I am pretty old and tend to avoid the
currently popular "dirty" words. Especially in front of grandkids and other
youngins.

Also, see darn, dang, and other variants.

 

[Guest]

eOK, so not only am I a newbie too dull to fix the form, now I'm an old lady
too! (It must be true since I am prior to 1957.) Please note that "dagnab"
was used as a euphimism to convey intent, as opposed to the words used in
real life. Now, Wayne, let's take on English slang - have you snogged anyone
lately?

 

[Guest]

This morning, for some reason, I followed your directions and it worked
perfectly! (Operator needed a night away from the computer.) Many thanks.
However, before I open the checkbook, the dropdown list I expected does not
appear - just the first record of the dropdown list.

 

[Guest]

Have you tried just making a new form using the wizard? I'm not even sure I
understand what the problem is, but IF I do, then I think it might be related
to the fact that you have a form based on a table that you've subsequently
changed (adding fields to it), and you expect those changes to be reflected
in the form you created based on the old table.

Total shot in the dark there. Dagnabit, i wish I had more for you....

 

[Guest]

I have been able to fix all of the drop down lists now except one, which is a
simple one with only two choices. I don't know if I've incorrectly designed
it as a Value List int the table design.