Re: Search and insert into continuous subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

tompk wrote:
I have a form (Frm_RTP_MAIN) with a continuous subform
(Frm_MAIN_MULTIPLES) that has a search button on it. It opens a
search form that allows the user to search the main table records and
highlight the record they want to add. I have the code pasted below
that I have used in other search forms (which are not continuous and
open a main form instead of a subform).

When I use this code, it opens the form but I actually want it to
insert the record into the row in the continous subform inside the
main form. And then continue searching and adding records as many
times as they need to. There is an Add button to for when their
search comes up null.

Access adds all records to the end of the file and uses indexes to show any
other order so you can't just insert the row into the subform.
You could pop up a form, fill it in , then have it "inserted" in some way by
a requery.
If it's inserted in an alph or numerical sequence and will "fit" there is
not problem.
If it is an arbitrary insertion, (John goes between Fred and Adam.) then you
have a prolem.

I can think of only one way to do this and it would be awkward.



.

Relevant Pages

  • Re: Google query box; Safari insertion point does not stay "blinking"
    ... Lately, however, I notice that when the page opens, the ... box where one would insert text will have the insertion point blinking ... but then for some reason the URL loads again ... and the insertion area blinking will ...
    (comp.sys.mac.apps)
  • Re: Search and insert into continuous subform
    ... Thanks Mike for your response but I am not sure if I am following you.....I ... my code simply opens up the Frm_MAIN_MULTIPLES on ... open a main form instead of a subform). ... If it is an arbitrary insertion, then you ...
    (microsoft.public.access.formscoding)
  • Re: Search and insert into continuous subform
    ... The query will be a neater solution ... when they double click to add it, my code simply opens up the ... continuous and open a main form instead of a subform). ... If it is an arbitrary insertion, ...
    (microsoft.public.access.formscoding)
  • Re: Google query box; Safari insertion point does not stay "blinking"
    ... Lately, however, I notice that when the page opens, the ... box where one would insert text will have the insertion point blinking ... Try waiting until the page finishes loading before you start typing? ...
    (comp.sys.mac.apps)
  • RE: Open a form within a subform
    ... I don't understand the 'all sub-forms run off the same query' I was ... withing the margins of the subform. ... The current form loads all the fields from each sub-form as you move ... When the form opens, it opens as a full screen document. ...
    (microsoft.public.access.forms)