dumb question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is a pretty elaborate access database i'm working in. Where can i see
where the information i'm seeing in access is being pulled from? does that
make sense?
 
are you "seeing the information" in a query, form, or report? if so, open
the pertinent object in design view. in a query, the underlying table should
show in the top section of the query grid. in a form or report, press
Alt+Enter to open the Properties box if it isn't already open. make sure the
title bar of the box says "Form", then look at the RecordSource property for
the name of the underlying table or query. if it's a query, then close the
form and go find that query in the database window and open it in design
view to see the underlying table.

the above will work if the data is coming from a native or linked table. if
the object is bound to a recordset, it'll take more digging to find the
reference to the data source. but start with the above and see what you come
up with.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

individual reports 1
Access Access 0
Front End Back End 2
Please help! date showing as 1900/01/00 2
Report Record Source 3
PowerPoint Super Stuck and Desperately Need Help 0
Access #Error & Excel Pivot 0
Moving Router 2

Back
Top