Add New Record between form & subform

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

Guest

Hi I was wondering a easy way to this. I have a form that I need to update
on a regular basis. I want to be able to open it up the form without having
to go through every record saved to a property to add a new infomration.
Thanks,
keri
 
Explain a little more as your subject does not match the rest of your post.

You can not add a record "between form & subform" as records are stored in
tables - not in forms.
 
I'm sorry I mean to say synchronize my form and subform. I have three tables
to my data base. The form I'm using updates on a monthly basis to records in
one of these tables. When I go in to my form to update a record I have to
scroll though all the previous ones I have entered to add a new one. If this
is to confusoning I can explain further.

Thanks,
Keri
 
If this is to confusoning I can explain further.
Yes it is still confusing.
A form/subform needs to be linked Master/Child on a common field like
primary key/foreign key.
 
it's not clear whether you want to go directly to a new record in the
mainform, or in the subform. to go immediately to a new record in the
mainform, try adding a move command to the form's Load event, as

DoCmd.RunCommand acCmdRecordsGoToNew

if it's the subform you want to go immediately to new record, try adding the
code to the mainform's Current event, as

With Me!SubformControlName.Form
DoCmd.RunCommand acCmdRecordsGoToNew
End With

though i have to say that i don't always have success with these types of
commands running from a mainform but intended for execution in a subform.

you may also need to add a extra line of code for cases where the form (or
subform, at least) is already at a new record, as

On Error Resume Next

add that code immediately *above* the "go to new record" code.

hth
 
I'm not sure why its not working right. I have a form and a subform. The
information in the main form is perment it will never change.
Project Name
FHA Number

The information in the subform will be update monthly
Mnth/Yr Sent
Missing Report
Date Recevied
Etc.
What I need it to do is go to a new record in the sub form but with the FHA
Number still to be there since this is my linking field to the mainform.
I'm just trying not to scroll though dozens of records that I have saved just
to add a new one.
Thanks,
Keri
 
i understood your scenario from your earlier posts, hon. the suggestions
i've already made are all i have to offer you as solutions, i'm afraid. good
luck with it.
 
Back
Top