limit to list (1 Viewer)

[steve111]

hi

In my forms quote and orders I have subforms
these subforms fetch parts from the stocklist
when I select the productno the material comes with it ( all good)
what I want to try and do is not limit the productno or material to the stocklist

when I try to changed limit to list to "no" it tells me I need to change widths etc
I have tired this but not having any look . not sure if it can be done
any help appreciated

I have attached a sample database

steve

 

[Delid4ve]

Think this maybe what you need:

Allow value list edits: Yes
Limit to list: Yes

After Update Event:

'Get confirmation that this is not just a spelling error.
StrTmp = "Add '" & NewData & "' Add data as a new product/order?"
If MsgBox(StrTmp, vbYesNo + vbDefaultButton2 + vbQuestion, "Not in list") = vbYes Then

'Append the NewData as a record in the table.
StrTmp = "INSERT INTO yourtablename ( yourfieldname ) " & _
"SELECT """ & NewData & """ AS yourfieldname"
DBEngine(0)(0).Execute StrTmp, dbFailOnError

'Notify Access about the new record, so it requeries the combo.
Response = acDataErrAdded

 

[Delid4ve]

Tablenames/fields/querys/forms very confusing and no standard in place for naming.

Im not sure your tables are correct either. You seem to have an orderdetails table, which i assume is meant to be a junction table between stocklist and orders but only one relationship.

Would a quote relate to an order rather than a stock list? I'm assuming your quoting and then an order is generated from a quote?

 

[Delid4ve]

have changed to show you slightly.

I think you'd be better off with one table for quotes/orders and probably still to be added is invoices.

have a look at the relationships window now

 

[steve111]

hi

I am unable to open the file .it is I think because it says its a PHP ext

steve

 

[steve111]

the quote is sent to he customer then if he agree I send them an order, sometimes I don't need to raise a quote just the order. and some times the order will not always reflect the quote

the subforms are parts from the stocklist that I will quote on and also sell .

but sometimes I could sell Labour ( people ) for a few days and that information would go on the quote etc

that's why I want to be able to input what I want

thanks steve

 

[ypma]

"I am unable to open the file .it is I think because it says its a PHP ext"
Try a differnet browser i use "Mozilla firefox" and have no problem in opening the attachment .

Just an idea Ypma