Opening of subforms

[Ryno Bower]

Hi.

I would like to do the following. This is what I have

Table - Operators with the following fields
Operator (Primary key)
Username
Password

Table - OperatorDetails with fields
Operator (Prim Key)
FirstName
LastName etc...

There is a one-to-one relationship between the 2 tables above.

I have a form called - AddOperator
On this form I have a button called "Edit operator details". When I click on the button I want it to open another form called "OperatorDetails", but must be linked to the current operator on the form "AddOperator".

E.g. In Form "AddOperator", field Operator I have BRENDA.
So when BRENDA is in that field and I click on the "Edit operator details", then the "OperatorDetails" must open with BRENDA already filled in in the field "Operator".
This would help me if I do a query that i can link all the ddetails between the two tables.

Any suggestions is very welcome,

Thanks
Ryno

[mshmyob]

I keep looking at your table design and keep scratching my head.

First the two tables are not related to each other since you have no foreign key. But more importantly why would you create two tables for this so called 1-1 relationship.

If you have an Operator table and each "operator" is only allowed one username/passowrd then all your data (ie: first/last name, username/password, etc.) should be contained in a single table.

Maybe I am missing something here because you have not given enough info but my suggestion is that you combine into a single table and if you feel so inclined, you should read up on normalization.

Like I said I may be missing something and if I am please enlighten me and I may be able to help better.

cheers,

[Ryno Bower]

OK, i followd your instruction, to keep it all in one table. I have done that.

This is what I have now.

Table: Operators
Fields: Operator(Primary Key), Username, FirstName etc
Forms: AddOperators, OperatorDetails

In form "AddOperators" I have fields to to add a new operator along with the username and password. On this form I have a button "Edit Details"

When I click on the button, I want the form "OperatorDetails" to open baed on the details I just filled in on form "AddOperators".

E.g.
On "AddOperators" field "Operator(Prim Key) I have ESTVEN, so when form "OperatorDetails" opens it must open so that I can fill in the details for that specific record just filled in in form "AddOperators"

I have tried many different methods but t doesn't work properly. If someone can provide me with a code which can do the above explanation, I would be so happy.

Thank you!

[mshmyob]

Ryno, I think you are over complicating this issue. Since the data you need to add/edit is in a single table you just need a single form that is bound to that table to accomplish everything you want to do.

The simplest way might be to add a button to add a new operator otherwise you are in edit mode.

Code for the add/new button click event is as simple as:

DoCmd.GoToRecord , , acNewRec
 

This will put you in append mode and allow you to add a new operator.

Otherwise just use the navigation buttons to scroll through existing records and edit them when you need to.

If you really need to open a new form then open the form with the openargs flag like so:

DoCmd.OpenForm "YourDetailFormName", , , , acFormEdit, , OperatorID
 

In the ON Open event of the detail form you grab that passed variable as so:

Dim txtOperatorID as String
' assign the passed variable to your variable above
txtOperatorID = Me.OpenArgs
' assign the passed variable to the control on your form
Me.txtMyOperatorID = txtOperatorID
 

But like I said I don't believe you really need the second form.

cheers,