more than one subform

[skate]

I currently have a subform in datasheet view that displays all my records. Unfortunately it is too much info that the user must scroll horizontally. I was thinking that I could still have this subform w/ limited information and have a second subform that shows the rest of the info depending on which item is selected. How would I go about this?

 

[llkhoutx]

Bad idea. If you have two subforms displaying the same data, you have some write conflicts and you may get error messages when the send tries to update after the first updates.

Better idea is to redesign you table to include less fields. Is you table normalized?

 

[skate]

What do mean normalized? Is there a certain standard? Sorry, I don't know very much about access. Yeah, I guess I should think of redesigning it.
Basically I have a load of records and I want the user to be able to search by company, location, description...etc. and then receive a list of all the entries containing the value(s) searched. I originally left it as a datasheet so that users could just use the "Find" button, but it is not such an obvious function for everyone. I'd like to create my own searches much like a query where the USER gets to enter what they want to search for. Any suggestions? Help!

 

[llkhoutx]

Get you a book about relational databases.

You learn a great deal by studying the code of others.

I suggest any of Litwin, Getz, et al's Access Developer (Desktop) Handbooks. There's an edition for each version of Access. Each is accompanied by a CD with the code.

Also Getz, Litwin & Baron's Access Cookbook, published by O'Reilly. It has lots of good coding tricks. It's accompanied by a CD with the code.

Also Access 2000 Answers published by Osborne. It answers lots of simple questions. No CD.

Welcome to the world of IT. There's always a learning power curve.

Also review the various postings of this site.