I need your help

[mjf_q8]

I face problem when I add a new record to the sales entry form.



How can I insert the Employee ID into order table throw the form and for the related user?



Please find attached my initial database.

Appreciate your help.

 

[MStef]

Hello mjf!

I don't know what do you exactly want.
I added a record vai "SaleForm", and the record
is saved in order table with EmployeeID (1).

 

[GaryPanic]

not a lot to work with here so let see if I have this right

you have an order form tied to a table (good) and you have a employee that you wish to link to this order

right you need an employee table (I have not looked at your d/base)
now you need a combodropdown box tied to your table of employees (better yet a qry which is tied to your table)
make your qry 2 fields long the first will be the ID number the second the name

id name
1 Big Bad Dave


now on your order table you need employeeid (number)

in the after update properties of your combo box have
employeeid= comboboxxx.coloumn()
me.refresh



comboboxxx= name of combo box
for more insight look at the attached zip file and customer form (not the flash one)

hopefully this shows what you are trying to achive --

in future can you give a bit more info

 

[mjf_q8]

I don't know what do you exactly want.
I added a record vai "SaleForm", and the record
is saved in order table with EmployeeID (1).

Dear Mstef,

I use the example you send it to me before, but I change the EmpID & OrderID to AutoNumber instead of text format due to my project requirements.

But when I login to the order screen the EmpID not initialize to this form.

Appreciate if you can fix this and forward to me.

Best Regard.

 

[MStef]

Hello Meshal!

OK, you mean, you want to populate "EmployeID", "First name", "Last name"
automatic, (in SaleForm).
I made a change in LoginForm (Sub cmdLogin_Click).
I added "Sub CustomerID_AfterUpdate", and "sub Form_Close" in SaleForm.
When you populate "customerID", this 3 fields will be populated depending
on "User name" in Login Form.
Here it is.