scroll bar in form

[johnnyc11]

I have a form that shows up as a datasheet and dispalys all the records in the database. I have a macro that I adapted from one of microsoft's templates. The macro is activated when the primary key of the record is clicked. The macro copies the ID number and finds the corresponding record using a different form that I use to input data. The macro successfully finds the corresponding ID, but the form that it opens does not have a scroll bar. I need to be able to scroll up and down because there are more fields as you scroll down. Other than that, the form seems to be able to save the fields I edit and the other tabs on the form also work. If I open the form from the navigation pane like a normal form there are scroll bars and it works well. Can any one help me add the scroll bars?

JPG of macro is below



Thanks,
John

[Missinglinq]

Few experienced developers use Macros. Untested, but try removing the last comma and Dialog from the OpenForm line, and see if that helps:

, Dialog

Linq ;0)>

[johnnyc11]

wow I didnt even notice that. THANK YOU!

[Missinglinq]

Did that solve the problem?

Linq ;0)>

[johnnyc11]

yes thank you very much!

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>