value from another field

G

Guest

I have a form frm_bundlelog with a subform on it frm_bundledocs.

On the frm_bundlelog I have a field CDoc that takes the count of records in
the subform. I then have a field numberdoc that has as its control source
tbl_bundle.NumberDocs. I would like to have the value from CDoc copied to
numberdoc. This seems to be working, hwoever only if the value from CDoc is
of one digit (1 to 9). If it is in double digits, the value doesn't appear
or simply returns a value of 0. Any idea why?

Basically what I want to do is returned the number of docs in a bundle
(based on the count of the subform) and return it to my tbl_bundle.

Any information as to how I can get this done is greatly appreciated.
 
G

Guest

J-F,

Without your code or an explanation of how your are currently performing the
copy of the value from the subform it is very hard to troubleshoot your
problem. Please paste the code you are using so that we can review it, and
propose solutions.

This said the basic synthax for retrieving data on subform is

Forms![FormName]![SubformName]...[SubFormName].Form.[ControlName]

Daniel P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top