Hello
I have made a database for the medicines business and I need some help to complete it.
I have a form which is our entree table and there are medicine code,medicine name , buying price and some other informations on it.
I have another form that is our source for invoices as medicine code,medicine name,selling price ,date of sell and so on.
I have another form wich calls description and in this formI have a complete list of all medicines that we buy and sell.in this table we hace medicine code ,medicine name and some other informations .
the sources for all the forms are tables
now the question is that I want when I write or choose by a combo box a medicine code in entree form or selling from ,system finde the medicine name from description form and fill the medicine name autumatcally
I tried thin function by "Dlookup" but it doesn't work
may somebody please help me?
I have made a database for the medicines business and I need some help to complete it.
I have a form which is our entree table and there are medicine code,medicine name , buying price and some other informations on it.
I have another form that is our source for invoices as medicine code,medicine name,selling price ,date of sell and so on.
I have another form wich calls description and in this formI have a complete list of all medicines that we buy and sell.in this table we hace medicine code ,medicine name and some other informations .
the sources for all the forms are tables
now the question is that I want when I write or choose by a combo box a medicine code in entree form or selling from ,system finde the medicine name from description form and fill the medicine name autumatcally
I tried thin function by "Dlookup" but it doesn't work
may somebody please help me?