WorkorderID problem

[coolcatkelso]

Hiya

I have a form which has a subform for products

The sub is linked to other forms as well.. I've included a pic to show the problem

Cheers guys
________
EFFECTS OF ZOLOFT

 

[missinglinq]

Screenshots of forms are very seldom are of any value in solving problems here, because no one here can "see" the code behind the forms shown! Where is the WorkOrderID supposed to be coming from? Is it an undisplayed field of the main form record? What datatype is it? Does it have a corresponding field in the subform's records? If so, what is its datatype?

 

[MarkK]

I don't get the question. I understand that there's no data in the WorkOrderID field, OK, and it should show automatically. Do you need to know how to write data to a particular field in a particular record?

 

[coolcatkelso]

Hi guys

Sorry for the lack of imformation

The workorderID comes from another table

The way I bring it into the current form is -
Default Value =[Forms]![Quotes]![WorkorderID]

This seems to work perfect for all the other records apart from this first one. This I have to do manually

I have included the Dbase should you wish to look at it

The form in question is QUOTE

Open the Dbase, main form pops up and click on the little tab, "Quote"
press ok to the window, then your into Quotes.. Fill out the top info with anything, and then click on Create workorder.. this will create a new workorder and workorderID, fill out the info for materials and you will see the WorkorderID is there for the 2nd line but not the first.. Once this is done, youc an click on Update workorder, and this will now copy the record from the Quote and produce a workorder instead
________
Lovely Wendie99

 

[coolcatkelso]

Ah seems to be fine now guys.. Didn't think of having a refresh command onChange lol simple little things
________
Healthy Relationship Advice Forum