Form Command

[francogaspari]

Hi.
if i have two forms , "frmNewClient" (where to add the new clients) and an "frmOrder",


and beside the box of the client name on "frmOrder" i create a command button and name it "ADD NEW CLIENT" in case i need to add a new ONE
my quest. is how can i link this button to open the "frmNewClient", and the time i add the new client and save it , i need to display automaticaly the name of the new customer ,that i already added, in the client name box, on "frmOrder" to continious my Order details.
thank you.

[ItsMe]

You want to open a form that pops-up so a user can add a new record to a table?

Docmd.openform, acform "formname"

The trick is saving records so any bound forms that remain open during the append process do not throw a warning to the user that the record they are on has been edited by another user.

[francogaspari]

ItsMe thank you .
but what i need exactly is, i want to an auto display of the name of this new client in the client box on frmOrder, without to search on his name again by a combo box for example. so will that works?

[ItsMe]

From within your frmNewClient form

Forms!frmOrder.TextBoxName = Me!ClientField

[francogaspari]

ItsMe thank u so much
but i am not an expert one here. can you explain more ?

[ItsMe]

What do you have so far? I understand you have two forms. What have you tried and what functionality works? Post code.

[francogaspari]

this is an example, and what i asked , as i am new on ACCESS , didn't understand well where to put this code>>>>

[ItsMe]

So you want to add the value from the field ID (tblClients) to the field ClientName (tblOrder)?

A typical way to do this is to add a combo to your frmOrder. Include the ID field and the description (maybe FirstName and LastName fields). Adjust your combobox's Bound Column property to be column 1 and the combobox's Bound Column property to be your ID field.
http://www.datapigtechnologies.com/f...combobox3.html

[francogaspari]

ItsMe thank you again .