By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,693 Members | 1,671 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,693 IT Pros & Developers. It's quick & easy.

Question about forms

P: 250
I have a form that i made that is going to be used on a handheld tablet pc in the field for inspecting hydrants. The screen is small so the main form just displays the most commonly used info. What i would like is another form that displays more details such as specific parts of the hydrant and if any repairs need to be done. right now i have created another form based off of the same table just showing the different fields that i want. the problem is, is that that form is not referring to the same record currently open in the original form. it just defaults to the first record in the table. any suggestions on how to get that second form to always open to the same record as the first form, or any suggestions on a better way to do this as i am getting stuck here lol... thanks for your help and sorry if i typed this too confusing.
Jul 22 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 931
I'm going to assume that you're using DoCmd.OpenForm to open the second form. If that's the case, take a look at the fourth (optional) argument. This allows you to build a WHERE condition into the opening of the form so that the form opens on a record (or set of records) specified by you rather than just the first record.

Jul 22 '10 #2

Expert Mod 15k+
P: 31,769
I would consider opening both forms at once, but ensuring the form for the extra details is set invisible upon opening. A button on the main form would set the filter of the second form and then show that form at the same time as hiding itself. There would be a button on the second form that, when you're done looking at the details, would switch back in the same way except it wouldn't touch the filter of the main form.

Does this sound like it could work well on a hand-held?
Jul 22 '10 #3

Expert 2.5K+
P: 2,653
Just instantiate form class object and this will give you access to form's instance properties/methods.

See also this article

Jul 24 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.