Can you change a form recordsource? Or is it only subform?

Hi,
Access 2007:
Can anyone tell me if there is a way of programmatically expanding a
subdata only for the currrent record in the data being viewed. I

Could someone please advise me what code I would need to add to my form to
time a user out of a form completely when they have been idle for a
predefined timescale, say 5 minutes?
Thanks,

I need some assistance with the DMax function.  I have a form with a subform.
The record source for the subform is SELECT [tbl_detail].[record_id],
[tbl_detail].[parent_no], [tbl_detail].[stc_no], [tbl_detail].[pz_acct_no],
[tbl_detail].[ctr_nm] FROM tbl_detail;

I am working on a databse that collects records for parts that are being
tested. I got a new requirement that they want the testers to record a value
every tenth record. I am wondering if anyone could help me try to figure this
out. I have tried but keep having to start over ...

I have a passthrough query that that I created through code and when I
execute it via docmd.OpenQuery I can see the correct results. How would I go
about getting this data into a table I have built through VBA?

I have 3 controls on a form
txtmemnbr, txtcategory and txtregnbra
txtcategory is a combo box with 4 possible values Full, Associate, Employee
and Student

I have three levels of tables:
Tbl_Project
Tbl_VariationOrder
Tbl_Obstruction

I will start by warning that I come from a world of procedural programming,
where problems like this would not occur.
In several applications, it is necessary to search for a Product Code, which
is as difficult as you want to make it - I have recently found that the Text

The newer version of Access allows multivalued fields, something I am
familiar with from Pick.
Are there any new (string handling) functions in VB that will allow working
with these?

When the main form opens it has the customerID and CustomerName displayed.  
The subForm uses a query to pull data from a table using the CustomerID on
the main form.  
The subForm does not appear.  It's visibilty is set to true.  When I open

I have a Continuous Form with about 15 fields, 4 of which need to be entered
as a minimum for our in house data purposes. This form is connected to a
Sub-Table called "tbl_CalwinMainSub" and is the "many" part of the
relationship.The four fields that need to be filled out are ...

Anyone have information or a website that can help me make a front end
for my program?
Ryan

Hi All,
I am able to code user access level at the form level, but can i also allow
user access based on their level for tables and queries?
I have three levels of access:

BACKGROUND:
1) Form (with subform) does not allow edits in order to safeguard data
from unintentional updates.
Form Properties - Allow Edits - No