Re: Linked Form Not Allowing New Records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ill try that. I was thinking you were recommending that as a last
resort and that I should try to stick with subforms. I already have a
tabbed control with each page a different subform which works great.
The problem is that control is on the from linked from the main one.
Ill try to either combine them into one form with subforms or use the
default value propety as you suggested. Thanks a lot for your help!


Rick Brandt wrote:
Rob wrote:
Hey Rick. Thanks for the advice. I didnt realize that about linked
forms. Its hard for me to describe what Im working on because I cant
talk about the data but I actually started with linked forms because I
have too many subforms to fit on one main form and be usable. Are
there any other options Im not thinking of as far as subforms? I want
to make this as user friendly as possible and the linked forms
definitly work better for what I have.

If you set the default value property as I suggested and make the linked
form a modal form it should work. Did you try that?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

.

Relevant Pages

  • Re: Linked Form Not Allowing New Records
    ... Rob wrote: ... Its hard for me to describe what Im working on because I cant ... have too many subforms to fit on one main form and be usable. ... definitly work better for what I have. ...
    (microsoft.public.access.forms)
  • Re: SubForms - Before Update Problem
    ... field in my code that's causing the problem... ... I am gonna work on this because I have same event in other subforms which do ... BeforeUpdate event of a form. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Use main form and subform to create single record
    ... I have a form and 2 subforms that use the same table as ... the record source. ... these forms combined into a single record on the source table. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.forms)
  • Re: query update
    ... If you have multiple tables in your query that suggests that they have ... single table thus allowing edits and the subforms MasterLink and ChildLink ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Tab Controls-4 subforms with the same record source?
    ... On each tab, I put 4 subforms named Subform1, Subform2, ... second page, and then click on the third tab, it pops up an error message. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)