Calling forth a form using 2 identifiers!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used this before in previous databases but for some reason, it's not working in this one.

I have a text box. I command upon clicking, for it to open up another form, based on mainform[caseno]=[caseno] & mainform[date]=[date]. (using correct language, of course). Anyway, I also set the default value on the newly popped up form to be the same as the underlying form. This worked before, because it not only created a new record when there was no related record, but it also called it back up once the new record was created. This time, however, when I specify both identifiers, it only calls up a blank form and does not allow me to enter a record because it would be duplicate. BUt, at the same time, it filters OUT the originally related record. I hope this makes sense. Anyway, what am I doing wrong?
Thanks, Melissa
 
Just a guess (without seeing your code and such), but are you opening the
new form in "Add" mode? If yes, that likely will create your problem.

--
Ken Snell
<MS ACCESS MVP>

Melissa said:
I have used this before in previous databases but for some reason, it's not working in this one.

I have a text box. I command upon clicking, for it to open up another
Click to expand...
form, based on mainform[caseno]=[caseno] & mainform[date]=[date]. (using
correct language, of course). Anyway, I also set the default value on the
newly popped up form to be the same as the underlying form. This worked
before, because it not only created a new record when there was no related
record, but it also called it back up once the new record was created. This
time, however, when I specify both identifiers, it only calls up a blank
form and does not allow me to enter a record because it would be duplicate.
BUt, at the same time, it filters OUT the originally related record. I hope
this makes sense. Anyway, what am I doing wrong?
 
Nope. Still not working. IThe datamode in the macro writer was not set to anything. Then I set it to edit. still not working. :(
 
You'll need to post more detailed information if we're to try to help here.
Post code; post setup of the forms; etc.

--
Ken Snell
<MS ACCESS MVP>

Melissa said:
Nope. Still not working. IThe datamode in the macro writer was not set
Click to expand...
to anything. Then I set it to edit. still not working. :(
 
Back
Top