Insert Record Problems w/ Tab Control

[HateSpam]

I have a read-only form that allows the user to browse clients. There
are buttons on the form that allow the user to 'Add New' or 'Edit Existing'.

They both lead to the same form: frmClient

frmClient has a single hidden field (ClientId), and a tab control with
several pages. Each page holds a subform that lists respectively client
details, invoices, payments, notes, etc. It is designed to only view 1
client at a time, ie - no scrolling through records on this form. That
can only be done on the form that calls it.

The 'Edit Existing' works fine with the commands

strID = CStr(Me!fsubClientBrowse.Form![ClientID])
strLinkCriteria = "[ClientId]=" & strID
DoCmd.OpenForm "frmClient", , , strLinkCriteria

However, I can't seem to get 'Add New' to function correctly. I am trying:

DoCmd.OpenForm "frmClient"
set frm = Forms!frmClient
frm.AllowAdditions = True
DoCmd.GoTorecord ,,acNewRec
frm.AllowAdditions = false

This creates a new record in the first page of the tab control, but not
on frmClient itself, which is sitting on the first record in tblClient,
and to which all the subsequent pages link to.

I can't create a new record and then snag the autoId and THEN open the
form, because there are required fields for the record that also do not
have defaults.

Suggestions?

[HateSpam]

HateSpam wrote:

I have a read-only form that allows the user to browse clients. There
are buttons on the form that allow the user to 'Add New' or 'Edit
Existing'.

[snip]

Is there anyone who can help with this? Should I state the problem in a
different way?

[Bob Quintal]

HateSpam <Ha******@nospam.com> wrote in
news:wz********************@fe2.columbus.rr.com:

HateSpam wrote:

I have a read-only form that allows the user to browse
clients. There are buttons on the form that allow the user
to 'Add New' or 'Edit Existing'.

[snip]

Is there anyone who can help with this? Should I state the
problem in a different way?

Teranews seems to have lost my original reply, so again
just
DoCmd.openForm "frmClient",,,,acFormAdd

--
Bob Quintal

PA is y I've altered my email address.

[Bruce]

HateSpam <Ha******@nospam.com> wrote in message news:<2b*******************@fe2.columbus.rr.com>.. .

I have a read-only form that allows the user to browse clients. There
are buttons on the form that allow the user to 'Add New' or 'Edit Existing'.

They both lead to the same form: frmClient

frmClient has a single hidden field (ClientId), and a tab control with
several pages. Each page holds a subform that lists respectively client
details, invoices, payments, notes, etc. It is designed to only view 1
client at a time, ie - no scrolling through records on this form. That
can only be done on the form that calls it.

The 'Edit Existing' works fine with the commands

strID = CStr(Me!fsubClientBrowse.Form![ClientID])
strLinkCriteria = "[ClientId]=" & strID
DoCmd.OpenForm "frmClient", , , strLinkCriteria

However, I can't seem to get 'Add New' to function correctly. I am trying:

DoCmd.OpenForm "frmClient"
set frm = Forms!frmClient
frm.AllowAdditions = True
DoCmd.GoTorecord ,,acNewRec
frm.AllowAdditions = false

This creates a new record in the first page of the tab control, but not
on frmClient itself, which is sitting on the first record in tblClient,
and to which all the subsequent pages link to.

I can't create a new record and then snag the autoId and THEN open the
form, because there are required fields for the record that also do not
have defaults.

Suggestions?

I think before we go any further it's important to know how you get
the other required fields into your client record. You will have to
create your client record before you can create any related records in
other tables. Your best bet is probably to use two separate forms,
one for entering the required client information and one for the 'edit
existing' functionality. Once the user has successfully created a new
client record then he/she could be automatically sent into the 'edit
existing' function.

Bruce