Adding an extra record base on value selected on current recor

Similar Threads:

1.Adding an extra record base on value selected on current record

Hi. Working on a split db 2000 and have a form with a subform where
I want some special action to take place. (frontend on local machine -
and backend on shared folder).

On my main form I also have a sub form. Applying a new record in
the sub form I want something to happen if the user selects a spesific
choise from a combo box.

This is what I want to do: First change the values in some of the fields
in the currentrecord. Then I want to have this record saved and then
I want automatically add an new record with custom calculated values
in it.

The reason I want it automatically inserted, is of the complicated
calculations.

In code behind the form, I can change some og the current fields
with code like:

me.SeconField = 3.5
me.ThirdField = 2
me.FourthField = 6      and so forth...

However, I cannot get this record saved.
Next I cannot automatically add a new record and then save that record.

Any help with this is much appreciated.

Regards
Jan

2.Default value of field in current record to be value of last recor

I am new to VBA and am learning.  But I need to get beyond this problem to 
get up and running.

I want to be able to allow the user to enter a date in a field on a form 
(call it a posting date) in the first record of the data-entry-session (not 
necessarily the first record in the underlying table).  Once that is done, I 
want the subsequent new record to be able to use the date from the user's 
first record as the default value for the current (new) record.

If the user should change the date after, say the third or fourth record, 
the program should remember the new date and make it the new default value 
for the user's next (new) and subsequent records until it is changed again by 
the user.

I don't seem to be able to find any literature on this 'ditto' dillema!
I would appreciate any input on this problem.  Thanks in advance.

-- 
Frank M
Hilton Head Island, SC

3.Adding new records based on current record

I am trying to add three new records to a table, based on the record that a 
user has just created using a form.  When the new record is created, I want 
to add three more records with different record types and clear some amount 
and date fields so the records are fresh for later calculations.  I have 
written a macro that accomplishes adding the records using a series of 
queries, but the fields are not in the correct order when I do the append.  
This seems to be a crude way to accomplish this task.  Is there a better way? 
 I have limited Visual Basic skills.

Thanks,
-- 
Karen Miller
Kansas City, MO

4.Select Q based on another Select Q (Add record problems)

Hi!

I have a Q (B) which is based on another Q (A) and a table (tblC). I have
created a relationship between QB and table tblC (autonumber field).

It seams that it not possible to add new records into any of the tables
involved. And to be able to add new records I need to create a completly new
query using all tables and criteras as I already have in QA.

Is this the way it sopose to work or am I doing something wrong here? Is
there a way around this?

It would be so nice to just have ONE QA and then base several other Q on
this to be used as recordsources for form. Which is the case with QB (I DO
have other names on my queries but to simplifye this msg I renamed them to
QA and QB).

TIA!
// Niklas

5.How do I select a record and if no record exists go to a new recor

(Newbie request)

I have defined a table where IDNumber is Indexed (Dups OK) and ReportDate is 
not indexed, but I want to create a query that returns the other data based 
on these fields and updates the form.  If there is no record for that 
IDNumber and ReportDate, I want it to select a new record to update.

Thanks in advance.
JPGeorge

6. add new record based on selected record

7. Subtract a field from a previous record from the current recor

8. Selecting Records base on current month