New fields in tables and forms

  • Thread starter Thread starter Double A
  • Start date Start date
D

Double A

I have added a few new fields to one of the main tables of my database and I
would like to add them to my form as well. The new fields automatically
updated the relationship and the query. However when I use the field list to
add these new fields to my form, they are not in the list. How do I get them
to update or refresh this list so I can add them?

Thanks.
 
go to the design view of the form

turn on the Properties window

select the form (one way is to click in the upper left where the rulers
intersect)

click on the Data tab of the Properties window

click in the RowSource property

click on the builder button [...] to the right

add the new fields to the form RecordSource

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*
 
oops, I meant click in the *RecordSource* property ...

RowSource is for combos and listboexes, RecordSource is for Forms and
Reports...

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*


go to the design view of the form

turn on the Properties window

select the form (one way is to click in the upper left where the rulers
intersect)

click on the Data tab of the Properties window

click in the RowSource property

click on the builder button [...] to the right

add the new fields to the form RecordSource

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
(: have an awesome day :)
*



Double said:
I have added a few new fields to one of the main tables of my database
and I would like to add them to my form as well. The new fields
automatically updated the relationship and the query. However when I
use the field list to add these new fields to my form, they are not in
the list. How do I get them to update or refresh this list so I can
add them?

Thanks.
Click to expand...
Click to expand...
 
Back
Top