tables and forms

[a.mlw.walker]

hi. I have two monitors. on the left I have a table with 120 000 entries. On the right I have a form, that searches the entries and shows me the data from the fields in textboxes. Each Time i search (the table is in alphabetical order) in the form, I have to check the table to see whether the company is there twice - because the form does not tell me that. for instance, there may be an entry for american express and another for american express PLC - same companies. Is there a way that when i click search, the table jumps to the same place that the form just jumped to?

Thanks
A;ex

 

[Dennisk]

I doubt it. As the table is not under form or program control. What you may have to do is to create a form for the table in datasheet view and sychronise. Although you will require a Primary key to perform the action you require. There is an access help topic on synchronising two forms.

 

[a.mlw.walker]

Thanks for reply

Thanks for replying, do you think you could give me a bit of a walk through for that. I havent been using access long

 

[Dennisk]

first use the form wizard to create your form and select datasheet mode.

Secondly on your main form, again use the wizard to create a button to open your newly created form and select the ''open form and tick the find specific data to display' option. On the next tab you can see the fields from the main form on the left and the fields from the form you wish to open on the right, just select the key on both side and click <-> then complete the wizard.

 

[a.mlw.walker]

Hi denisk, How do i make it so it doesnt search for the name in the WHOLE field but part of it, for instancee if i search for first choice, i want it to show me first choice holidays, first choice plc etc. also how can i get it to show me the result in a table.
thanks
alex