pulling datas from the table in the form

[tamilarasi]

Hi,



I am not sure whether i am doing it right. I have created tables and queries. I am trying to create a form . It would contain one field. When the values are entered in that field , it should produce the details pertaining to that field.

to give more details. I have two tables

order table: which contain order number, part number,....
supplier table: supplier name, invoice number ... so on

I wanted to have a form with order number blank. when either I type/scan the order number, it should pull the details of part number, supplier name, invoice number from the
two tables pertaining to that order number.
could you please help me...

thank you

[jjitss]

Perhaps you can use a search box in a form? I'm not sure this is exactly what you want, but I think it comes close.

- Create a form.- Place in the header an additional text box for input and a button next to it
- On the properties of the button, you select Event, on Click, Macro Builder
- Select the option Apply filter in the dropdown menu.
- Use an condition equivalent to: [NameVariableOrderID] Like [Forms]![NameForm]![NameTextBox]
Or use the folowing condition when parts of the order number are also fine: [NameVariableOrderID] Like "*" & [Forms]![NameForm]![NameTextBox] & "*"

For the combination of two tables, just select the query of the combining tables instead of one table as source.
I hope you find out!

[tamilarasi]

thank you for your reply. i followed the method

where command [Forms]![primary details]![Purchase Order Number]=[primary details]![Purchase Order Number]. It gets me to the blank screen..

thanks

[jjitss]

Are you using that command as condition of the filter?

[tamilarasi]

hi, i did used in the where condition... in build event
it opens up the form but on a add mode rather than pulling the details pertaining to that requirement.

[jjitss]

Is it possible that the condition should be:

[Forms]![primary details]![Purchase Order Number]=[Forms]![primary details]![and here the name of the textbox]

Name of the textbox is like Text76 or something (you can find it in the property sheet). Because you want the Purchase Order Number be equal to the text entered in the textbox, right?

[tamilarasi]

It is still the same. It opens a new window with "Enter Parameter Value" with primary details!Purchase Order Number!text0 and when i reenter the order number it opens up the form on an addition mode.sorry...

[jjitss]

Database141.zip

This?

[tamilarasi]

looks great. let me try my inputs.wonderful..

[tamilarasi]

Hi
database.zip

if you look at the database, when i do the search there is another pop-up says "enter parameter value" . then the value appears.
Is anything i have not considered in this

thanks

[jjitss]

Is database_Backup.zip this helpful?

[tamilarasi]

hi, that is wonderful. it works. I am doing a search with serial numbers, if you please look at my last added record.
My next step on this is to enable the other person to enter only the serial number .
for this i have disabled all the other fields except quantity ordered and serial numbers for the other person to enter those details on order received and save those record.
When i search through serial number, i am getting no datas retrieved. is it because i have got more than one serial number on the record??.
just attached the databasedatabase_Backup.zip

thanks for your help