Re: Have date automatically go into another form

thx tina

Can you also help me with one more thing

i have created a report from the table in which i have diffrent customers
and thier trasactions.

the report prints fine and everything is there i need need to get it
fitlered further.
i.e if for example i need to see the reports of the customer who have made a
purchase of $8,000.00 or above Only. can this report be shows from the same
the same table from which i am already making the first report?

please do reply.

rgds
Mika


"tina" wrote:

you've started a new thread, so for those of us who haven't read your
previous thread, this is kind of like turning on the TV in the middle of a
show - we don't know what the previous "advice" was, or any of the
information you posted before.

however...

its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to
the
approprite feilds as mentioned in the 2nd form...

you absolutely do NOT want to copy data from one table to another. use the
primary key (customer number) to *link* a specific customer to a record in
the other table - that's all you need, in order to make the customer data
for each record available in queries, forms, and reports. copying that data
into the second table is a violation of normalization rules.

Access and Excel are *very* different; they store and manipulate data very
differently; and your Excel skills mostly do NOT transfer to Access. you'll
have to learn to play a whole new ballgame. i strongly recommend that you
start by closing Access, and reading up on relational design principles; if
you don't do it now, you'll be doing it later - and kicking yourself because
you didn't do it now, and wasted a whole lot of time and effort doing things
wrong and trying to fix them. for more information, see
http://home.att.net/~california.db/tips.html.

hth


"mika" <mika@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7EA2A276-07E2-42A5-9A89-EA2F5BA30AEB@xxxxxxxxxxxxxxxx
Hi,

My question is pretty much same...but the diffrence is that its only been
2
days since i swtched from excel to access and i have zero knowledge of
access.

i actually followed your advice and made two table...however what i really
wanna do is something like...

first table i have assigned each customer a number like 1 for jhon, 2 for
wendy 3 david.

and in the other table with advices / receipts the details are pretty much
same...its just that i would actually want to use the identifying number
and
automatically pick all that data from first table and copy it directly to
the
approprite feilds as mentioned in the 2nd form...

any help would be appreciated...i am using acccess 2003 and been browsing
wevsite after websites trying to get the answer.

rgds



"Wayne-I-M" wrote:

Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the
invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to
select
the content of the second form filtered by the content of the 1st. Hope
that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Bianca" wrote:

Thank you Wayne,

both your suggestions sound good .... I think I like your second
suggestion
better - can you tell me though (as I said I am totally new to this)
.....how
to do this? I know I am asking a lot but I would really appreciate the
help

B

"Wayne-I-M" wrote:

Hi Bianca

If as you say most of the information is on both forms and assuming
that
there is a linking field you could simply have the invoice receipt
form as a
subform of the application form using the linking field as child
master.
This would mean that you would autofill the fields.

Or - assuming again there is a linking field the button you have
created
could be used to minimize the application form (but it would still
be open)
then use a setvalue OnOpen of the Invoice reciept to autofill the
fields.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Bianca" wrote:

Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and
forms.
My question is this: I have two forms one form is an application
for a
discount card that the company I work for sells - the second form
is the
invoice receipt - so basically is has most of the same information
as the
first form
Can I get the information such as name address etc to
automatically show up
on the invoice receipt form from the application form??
I have created a little button in the application form that brings
me to the
invoice receipt form - do I have to do something there??
Where?? As you all can see I dont even use the proper
terminology - but I
think I have managed to state my problem as plainly as possible.

Any help or advice would be appreciated - and as plain English as
possible!

Thanks




.