Autofill fields

[Nizar]

Hello everybody!
Im new in Access as well as in this Forum! Glad to be here
Im currently developping a small application in Access 2003 and here is my problem:
I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber"
Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox.
Note: SupplierName values are from other table: Suppliers

Any help is highly appreciated,

Thanks in Advance

 

[ajetrumpet]

Sounds like the setup is pretty normal.

If the relationships are properly set up, you will write an SQL statement with a JOIN in it for the combo box's rowsource. This article tells you how to do it (I assume, from the post, that "orderID" is another control on your data entry form - or at least I hope it is)...

http://support.microsoft.com/kb/319482/en-us

 

[Nizar]

Thanks ajetrumpet for your help,
I succeded to put OrderId in this form: "FRM/SupplierID/CurrentYear/" but i couldn't add the last value ...OrderNumber from the other textbox
precisely where to put the code? it's not wroking when i put it in the comboAfterUpdate()
thanks again,

 

[ajetrumpet]

What do you mean, I couldn't add the last value...OrderNumber???

Hopefully you're not pasting the code from the article in the event. You have to tailor it to fit your own needs (and control names!!).

If none of this is relevant though, did you change the column count and column widths of the combo box?? Those two properties are often missed when doing this...

 

[Nizar]

Im sorry if i wasn't clear in my post.
In the form I want to choose first the Supplier from a combobox then write the Order number in a textbox. This is the form of the OrderID field that i want to autofill: "FRM/SupplierID/CurrentYear/OrderNumber"
I succeded to autofill OrderID only in this form: "FRM/SupplierID/CurrentYear/".

Regards,

 

[Nizar]

ajetrumpet I think Ive got it, it is working now
Many thanks and sorry