Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access forms Basics 1

Status
Not open for further replies.

AGus01

Technical User
Sep 6, 2005
54
GB
Hi, I am new to access and Access forms.

I have inherited a database which uses access forms.

Please can you advise how I can view the underlying data behind each and every form. So I can work out a data information flow?

For example I would like to be able to Chart exactly which database tables/queries etc.. are being selected/updated from each and every form page.

Is there a way of switching to a source code view of a form?

I come from a SQL server/web background if this helps?

Thanks for your help in advance. Gus

 
Hi,

Highlight the form, click design, right click on the form and select properties and at the top you will see record source. this will tell you what queries or table the fform is looking at.
 
Hi Lars,

Thanks for your help. I can't get this to work. I select the forms Objects from the left hand menu.

I then select the form I am interested in and right click to go to design view.

Once in the form I right click anywhere on the form select properties and am given a menu with a drop down and a number of tabs. None show me the database queries the tabs are Format, Data Other, all.

if this helps?

thanks

Angus

 
Click in the very top left corner of the form - you will now have selected the entire form, and the data tab will show the source for the form.

Note the source can be a table, a SQL query string or a saved query. Watch out for queries based on queries!

SeeThru
Synergy Connections Ltd - Telemarketing Services

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top