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

Go to specific record on form open.

P: n/a
I want to be able to go to a specific record on my form when I open
it. The record I want to go to will be dynamic based on the value
currently stored in a global variable. The global contains the
primary key (long int - BlahBlahID) and there is a field on the form
(tbBlahBlahID) that contains the value for this field. I am having a
major case of DFUism here because this looks to be a simple request,
but my aged brain is stumbling on it. Please point me in teh correct
direction.

Thanks...

Oct 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 15 Oct 2007 12:53:20 -0700, DavidB wrote:
I want to be able to go to a specific record on my form when I open
it. The record I want to go to will be dynamic based on the value
currently stored in a global variable. The global contains the
primary key (long int - BlahBlahID) and there is a field on the form
(tbBlahBlahID) that contains the value for this field. I am having a
major case of DFUism here because this looks to be a simple request,
but my aged brain is stumbling on it. Please point me in teh correct
direction.

Thanks...
DoCmd.OpenForm "FormName", , , "[BlahBlahID] = " & YourVariableName
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 15 '07 #2

P: n/a
On Oct 15, 4:37 pm, fredg <fgutk...@example.invalidwrote:
On Mon, 15 Oct 2007 12:53:20 -0700, DavidB wrote:
I want to be able to go to a specific record on my form when I open
it. The record I want to go to will be dynamic based on the value
currently stored in a global variable. The global contains the
primary key (long int - BlahBlahID) and there is a field on the form
(tbBlahBlahID) that contains the value for this field. I am having a
major case of DFUism here because this looks to be a simple request,
but my aged brain is stumbling on it. Please point me in teh correct
direction.
Thanks...

DoCmd.OpenForm "FormName", , , "[BlahBlahID] = " & YourVariableName
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Wont that opne the form with JUST that record (ie I wont be able to
scroll through to other records in the control source)? Assume I have
50 BlahBlah records, I want to open the form with all 50 records
availabel just with the BlahBladID passed as the current record.

Oct 15 '07 #3

P: n/a
On Oct 15, 4:42 pm, DavidB <je...@yahoo.comwrote:
On Oct 15, 4:37 pm, fredg <fgutk...@example.invalidwrote:


On Mon, 15 Oct 2007 12:53:20 -0700, DavidB wrote:
I want to be able to go to a specific record on my form when I open
it. The record I want to go to will be dynamic based on the value
currently stored in a global variable. The global contains the
primary key (long int - BlahBlahID) and there is a field on the form
(tbBlahBlahID) that contains the value for this field. I am having a
major case of DFUism here because this looks to be a simple request,
but my aged brain is stumbling on it. Please point me in teh correct
direction.
Thanks...
DoCmd.OpenForm "FormName", , , "[BlahBlahID] = " & YourVariableName
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Wont that opne the form with JUST that record (ie I wont be able to
scroll through to other records in the control source)? Assume I have
50 BlahBlah records, I want to open the form with all 50 records
availabel just with the BlahBladID passed as the current record.- Hide quoted text -

- Show quoted text -
Thanks guys. I got it figured out...

Oct 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.