MS Access Question regarding multiple forms

[icanectc]

I have an issue with this access program I am working on - I have all the tables, reports, queries and modules setup but I have 2 forms - 1 form for all the end users to use so mgmt can track the work done for the day as the end user inputs the data and it gets stored in the tables;

however I have a 2nd form for the users incase the file has to go to a "2nd look" format where the users fill out this form for the reasons mgmt needs to look at the file; however its duplicating data like customer information and so on. I want to be able to have them fill out the first form then if determined by the company guidelines that a 2nd look is needed it auto fill in the generic information yet still allow them to add to the other fields but I dont know how to do this at all.

Anyone have any ideas??

 

[CEH]

It sounds like the direction you are heading is a split database. Access does it for you. This way you have your tables...Backend... on a server... Frontend on each station. With this you can set up forms for normal users and forms for Admin users. Different forms for different users all connecting to the same tables.

 

[icanectc]

Actually I think its more like the passing arguments - I did a search on the passing parameters words and came across a page that breaks this down using OpenARGs statements but I am just not a programmer and dont get the coding at all. Another post stated you can use filters but I dont know how to use filters. If you have any direction for me please let me know, thanks!

 

[icanectc]

Okay hereis what I have on the first form


Dim stDocName As String

stDocName = "Second Look"

DoCmd.OpenForm stDocName, , , , , , Me.Name

Where Name is the name of the field i want to pass to the 2nd form.
the code behind on the 2nd form has this:

Private Sub Form_Open(Cancel As Integer)
Dim Args As Variant

If Not IsNull(Me.OpenArgs) Then
Args = Split(Me.OpenArgs, ";")
Me.Name = Args(0)
End If
End Sub

But when i click the button to load the form I get a run-time error '2135': This property is read-only and can't be set.

Mind you I have relationships set up for a one to many with referential intergrity checked. I am not sure any suggestions?

 

[boblarson]

You can't set Me.Name that is a read-only property that it is talking about.