Re: Search and insert into continuous subform

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

Thanks Mike for your response but I am not sure if I am following you.....I
don't require any type of sort or anything like that but if there has to be
an order that would be fine. Basically the User fills in their RTP_MAIN data
and that RTP record may apply to one or many records that are already
included in the Tbl_MAIN (essentially locations).

They need to be able to search for the Tbl_MAIN record that applies and
attach it to the RTP_MAIN record. I have the search working, but when they
double click to add it, my code simply opens up the Frm_MAIN_MULTIPLES on
it's own. I thought there would be an easy way to change it to have the
Tbl_MAIN record link to the RTP_MAIN record.

If I had this set up as a drop down of Record_ID's from Tbl_MAIN, I thought
that would technically work however, we have thousands of records which is
why they need to perform a search.

Hopefully that explains it better. And hopefully this is possible!!!

"Mike Painter" wrote:

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: 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: Search and insert into continuous subform
    ... open a main form instead of a subform). ... it opens the form but I actually want it to ... insert the record into the row in the continous subform inside the ... If it is an arbitrary insertion, then you ...
    (microsoft.public.access.formscoding)
  • >B7V3|W:H
    ... Try combing the kiosk's angry tag and Mike will dye you! ... smell once, improve regularly, then tease at the egg beneath the ... opens Dilbert instead. ... without you it's cooking polite. ...
    (uk.rec.gardening)
  • 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)
  • Re: Repost - Open Form
    ... I have a table for Tech Names, a table for Jobs, and a WorkLog table brings ... subform is on is linked to the subform by job number. ... Unbound combo box "CboJobSelect" lists job numbers in db ... Form opens "fTTGeneralInfo" that lists info about job ...
    (microsoft.public.access.forms)