Subforms using the same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

Mike Pallos said:
I have a single table (tblNode) that I am using as the source for the main
Click to expand...
(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
Click to expand...
(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
Click to expand...
record in a single table? If so, what am I doing wrong?
 
Back
Top