Data a form shows question

[annietn34]

On my first screen I have "View my LIbrary" - you click on the button and it takes you to a form where you can choose a book from a drop down list and below that are fields that show you the author, number of pages, details of the book, etc. It all works fine.

My problem is when I click on the down arrow to choose a book it shows me the entire table rows - I only want it to show me a listing of the books only for me to choose from instead of showing me the entire fields!.

So how can I accomplish this?? No programming now - I am a very novice user here.


Also - can I do anything you can do without being able to put in code? - Just curious if you programmers had all the fun!

Annie

 

[Uncle Gizmo]

If you remake the Combo box with the combo box wizard it allows you to select the fields you want to display...

 

[annietn34]

still not working right

If you remake the Combo box with the combo box wizard it allows you to select the fields you want to display...

Okay - I know how to do that - I have more fields under this - - I click on the list choose a book thin under there fields it will show you this:

Author

Began

Finished

Comments

Rate

I did change the Combo box with the combo box wizard and select only the book - now it will not put what the author - comments, began - finished, etc. I just want only in the list to show my the books then choose a book and then the other fields will show me the author, comments, etc.

I hope you can understand!!

Thanks




Befor

 

[AN60]

Annie
If I understand you correctly you originally had a combo box that worked ok but when you clicked it you saw not only your book but other field names too. If that is the case it is not hard to fix. You will have to set your combo box as it was originally then go to the Properties for that combo. Look for Format then find Column Widths. Here you might need a bit of trial & error but you need to set the width of columns you do NOT want to see to zero. That way they will still be there but you will never see them & your combo should still work. Now to tidy it up a bit more you might want to set the List Width to about 3 or 4, trial & error again. The List Width just narrows the width of the list you see when you actually click the combo. You will just need to fiddle around to get it set to your preferences. Maybe write down your original settings so you can return there is necessary. good luck I hope that is what you want.

 

[annietn34]

Thank you!

Annie
If I understand you correctly you originally had a combo box that worked ok but when you clicked it you saw not only your book but other field names too. If that is the case it is not hard to fix. You will have to set your combo box as it was originally then go to the Properties for that combo. Look for Format then find Column Widths. Here you might need a bit of trial & error but you need to set the width of columns you do NOT want to see to zero. That way they will still be there but you will never see them & your combo should still work. Now to tidy it up a bit more you might want to set the List Width to about 3 or 4, trial & error again. The List Width just narrows the width of the list you see when you actually click the combo. You will just need to fiddle around to get it set to your preferences. Maybe write down your original settings so you can return there is necessary. good luck I hope that is what you want.

Only took me about 5 minutes of trial and error and it is perfect! Guess I should have explained myself better the first time! But thanks - it looks so much better - This is so much fun to me!

Annie