S
Sue M
Hi there,
I want to use either one of the above to find a record in
a large database from a form.
I understand if I use a dlookup I may also be able to copy
the previous record into the current form which would be
helpful.
So far every adjustment of code I have done (after reading
help files) to incorporate my own table or field names has
failed and I don't know why. Even when I have tried to do
a straight dlookup.
The dlookup I have tried was entered in the on click event
of a command button. The code is as follows:
Dim varX As Variant
varX = DLookup
("[tablefieldname]", "TableName", "[formcomboboxname] = " _
& Forms!Form Name!formcomboboxname)
I have also tried the following to find a record:
DoCmd.FindRecord "Item name to find",, True,, True
This works but I would like for a pop up box to appear to
ask for parameters. How would I do this?
Any other ideas for how to achieve any of these things
relatively simply would be wonderful.
Cheers,
Sue
I want to use either one of the above to find a record in
a large database from a form.
I understand if I use a dlookup I may also be able to copy
the previous record into the current form which would be
helpful.
So far every adjustment of code I have done (after reading
help files) to incorporate my own table or field names has
failed and I don't know why. Even when I have tried to do
a straight dlookup.
The dlookup I have tried was entered in the on click event
of a command button. The code is as follows:
Dim varX As Variant
varX = DLookup
("[tablefieldname]", "TableName", "[formcomboboxname] = " _
& Forms!Form Name!formcomboboxname)
I have also tried the following to find a record:
DoCmd.FindRecord "Item name to find",, True,, True
This works but I would like for a pop up box to appear to
ask for parameters. How would I do this?
Any other ideas for how to achieve any of these things
relatively simply would be wonderful.
Cheers,
Sue