I have a maintable Stak and subtables Detail1, Detail2. The detail forms are
linked to Stak as one to many by the stakNr field. I have enforced
referential integrity and cascadeupdating.
The form is bound to Stak and displayes one record at the time, and two

I can set up an unbound combo box to select a record (such as an Employee
record) based on what I select in the combo box, but I would also like to
have the Employee name displayed in the combo box when I open the form or
scroll to a new record.  The only way I have found to do ...

Please help me..
I am doing a application in Ms Access 2003.
I have 3 text files(Tab delimited data) like :
050825acrdata,

I have a form and a delete command button to delete the record from the
form.  The problem is that after the delete button is pressed, before the
access confirm delete message appears, the form displays the next record in
the table before the record in question is deleted!  So ...

I have a subform made from a query.
The problem is, the data shown in the form is locked. How can I alter
the data? If I pull the data from a table, I can alter it.
I can't mess with the tables and the form requires info from various

Help!
I need to create a form that has a calender look to it.
I have a table that stores schedule dates for  a room, the room can be used 2
hours at a time and normal day is from 10am to 8pm and there are three rooms.

I have a main form with a button on it that calls another form.  The button
has the following code:
==================================
Private Sub Add_new_payment_Click()

i need to be able to show amount in $ of rent due and the period it covers,
and also if tenant pays a little bit more so they are in credit, how to
calculate or show that.

I' have this form where the default view is datasheet. However, users
should be able to change to a continuous-form view.
When I set the default view to continuous-form, then it's no problem to
switch between datasheet and continuous-form. But when I set the

Although I am not new to Access, I am self educated so my knowledge is
inconsistent.  Before I begin, please know that I have read each and every
entry in both the reports and forms area, but most questions are much more
complicated and make assumptions.

I need to have fields that calculate totals on my form.  e.g Field [Qty]  
Field [price]  Field to show total.
In Paradox I think I created afield with   sum[Qty]:[Price] but that was
years ago.

Usually I'm using a procedure from a control on a form, as the following,
=Procedure([Form]) and on the procedure, ProcedureName(frm as form) to pass
all the controls.
Can I also call and pass all the variables from one procedure to another

I want to delete all data in a field with a command button.
What code must i write?
Svein

how can I generate a word form that will be able to match an access form and
be able to bring information to my access database

     Anyone try calling a SQL Server Reporting Service report from within
Access?  I have an Access application that uses SQL Server as the backend.
I want to have the feature from an invoice screen to create a PDF of the
Invoice report and then email it to the customer.