Subforms using the same table

[Guest]

I have a single table (tblNode) that I am using as the source for the main (frmNode) and subforms (fsubCost, fsubProb). The record source in a simple query going against the tblNode table. The reason I am using subforms is so I can use tabs (pages) to make the display look better. Everything looks great when I scroll through existing records. The problem is when I go to add a new record.

When I try to switch from the first tab (fsubCost) to the second tab (fsubProb), I am getting a null field error on one of the fields from the main form.

Can I use subforms in a form when all the data is coming from a single record in a single table? If so, what am I doing wrong?

Thanks in advance for your time. I've been stuck on this one for hours now..
Mik

 

[Arvin Meyer]

As soon as you switch tabs, you are moving off of an incomplete record. The
only way to do what you want to do is to use an unbound form and write all
the data to the table when you've finished entering it on the form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I have a single table (tblNode) that I am using as the source for the main

(frmNode) and subforms (fsubCost, fsubProb). The record source in a simple
query going against the tblNode table. The reason I am using subforms is so
I can use tabs (pages) to make the display look better. Everything looks
great when I scroll through existing records. The problem is when I go to
add a new record.

When I try to switch from the first tab (fsubCost) to the second tab

(fsubProb), I am getting a null field error on one of the fields from the
main form.

Can I use subforms in a form when all the data is coming from a single

record in a single table? If so, what am I doing wrong?