set information automaticlly in fields-forms

  • Thread starter Thread starter peter junker
  • Start date Start date
P

peter junker

I did write a database for my business - i'd like to administrate the items,
coustems etc...

i made a table for items, coustomers, invoice, orders and product group
etc..

after i made a form, where i can fill out the order from the coustomers, and
i want after i did wrote the coustomer number ( ID ) that in this form the
other fields, name, surname, street zip code etc.... field out automaticly .
I think i have to write a query. that compare the ID in the order_table with
the ID in the coustomer_table with a marcro , first i must take the fields
and then with a macro put in the dates from the coustomer_table? But it
doesn't work.

Then the same with the products ( items ) after i wrote the name of the
item, all fields should be filled out automaticly -

In the table for the productitems are all products only one time, in the
order_table i can put in the items always, not only one time!
 
Na rijp beraad schreef peter junker :
I did write a database for my business - i'd like to administrate the items,
coustems etc...

i made a table for items, coustomers, invoice, orders and product group
etc..

after i made a form, where i can fill out the order from the coustomers, and
i want after i did wrote the coustomer number ( ID ) that in this form the
other fields, name, surname, street zip code etc.... field out automaticly .
I think i have to write a query. that compare the ID in the order_table with
the ID in the coustomer_table with a marcro , first i must take the fields
and then with a macro put in the dates from the coustomer_table? But it
doesn't work.

Then the same with the products ( items ) after i wrote the name of the
item, all fields should be filled out automaticly -

In the table for the productitems are all products only one time, in the
order_table i can put in the items always, not only one time!
Click to expand...

After you filled in the ID and press enter (afterupdate for example),
you can use the DLookUp function to find the customer data in the
customer table.Like:
txtCustomerName=DLoookup("[CustomerName]", "Customers", "[CustomerID] =
" & txtCustomerID )
txtCustomerAddress=DLoookup("[CustomerAddress]", "Customers",
"[CustomerID] = " & txtCustomerID )
etc.
You can do that in code or using a macro (SetValue-action)
 
Hello Gijs,

sorry, but I didn't get it. I'm not so fit in programming access - the
database works, but i have to wrote all fields - if i wrote a invoice for a
coustomer i have to put all dates in the fields, access doesn't fill out
automaticlly. Id like to make it with a macro, but i receive always a note,
that the field isn't found ? IF I take setvalue the first field is the field
id like to update and under the first i have to put in where i have to take
the dates ? didn't work, maybe you can explain as a macro, thanks Peter

Gijs Beukenoot said:
Na rijp beraad schreef peter junker :
I did write a database for my business - i'd like to administrate the items,
coustems etc...

i made a table for items, coustomers, invoice, orders and product group
etc..

after i made a form, where i can fill out the order from the coustomers, and
i want after i did wrote the coustomer number ( ID ) that in this form the
other fields, name, surname, street zip code etc.... field out automaticly .
I think i have to write a query. that compare the ID in the order_table with
the ID in the coustomer_table with a marcro , first i must take the fields
and then with a macro put in the dates from the coustomer_table? But it
doesn't work.

Then the same with the products ( items ) after i wrote the name of the
item, all fields should be filled out automaticly -

In the table for the productitems are all products only one time, in the
order_table i can put in the items always, not only one time!
Click to expand...

After you filled in the ID and press enter (afterupdate for example),
you can use the DLookUp function to find the customer data in the
customer table.Like:
txtCustomerName=DLoookup("[CustomerName]", "Customers", "[CustomerID] =
" & txtCustomerID )
txtCustomerAddress=DLoookup("[CustomerAddress]", "Customers",
"[CustomerID] = " & txtCustomerID )
etc.
You can do that in code or using a macro (SetValue-action)

--
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Click to expand...
 
peter junker bracht volgend idée uit :
Hello Gijs,

sorry, but I didn't get it. I'm not so fit in programming access - the
database works, but i have to wrote all fields - if i wrote a invoice for a
coustomer i have to put all dates in the fields, access doesn't fill out
automaticlly. Id like to make it with a macro, but i receive always a note,
that the field isn't found ? IF I take setvalue the first field is the field
id like to update and under the first i have to put in where i have to take
the dates ? didn't work, maybe you can explain as a macro, thanks Peter

Gijs Beukenoot said:
Na rijp beraad schreef peter junker :
I did write a database for my business - i'd like to administrate the
items, coustems etc...

i made a table for items, coustomers, invoice, orders and product group
etc..

after i made a form, where i can fill out the order from the coustomers,
and i want after i did wrote the coustomer number ( ID ) that in this form
the other fields, name, surname, street zip code etc.... field out
automaticly . I think i have to write a query. that compare the ID in the
order_table with the ID in the coustomer_table with a marcro , first i must
take the fields and then with a macro put in the dates from the
coustomer_table? But it doesn't work.

Then the same with the products ( items ) after i wrote the name of the
item, all fields should be filled out automaticly -

In the table for the productitems are all products only one time, in the
order_table i can put in the items always, not only one time!
Click to expand...

After you filled in the ID and press enter (afterupdate for example),
you can use the DLookUp function to find the customer data in the
customer table.Like:
txtCustomerName=DLoookup("[CustomerName]", "Customers", "[CustomerID] =
" & txtCustomerID )
txtCustomerAddress=DLoookup("[CustomerAddress]", "Customers",
"[CustomerID] = " & txtCustomerID )
etc.
You can do that in code or using a macro (SetValue-action)

--
Click to expand...
Click to expand...
 
peter junker gebruikte zijn klavier om te schrijven :
Hello Gijs,

sorry, but I didn't get it. I'm not so fit in programming access - the
database works, but i have to wrote all fields - if i wrote a invoice for a
coustomer i have to put all dates in the fields, access doesn't fill out
automaticlly. Id like to make it with a macro, but i receive always a note,
that the field isn't found ? IF I take setvalue the first field is the field
id like to update and under the first i have to put in where i have to take
the dates ? didn't work, maybe you can explain as a macro, thanks Peter
Click to expand...

Dates?

Oh well...

First, determine where you want to fill these dates (at what point in
your form I mean)
Then, goto that control
Press properties and go to the AfterUpdate Event
Click the three dots and choose macro
Name the macro
In the list, choose SetValue
'Downstairs', right-click and choose build (exporession builder it's
called I think)
Select the form and then the control in the dialog that appears. Double
click that last one
In the second field, enter the expression. For today, the expression
could be =Now()
Or for a lookup, it could be =DLookup(<as mentioned earlier>)

You might be missing the = sign or you might have the item wrong if you
get an error.
 
Hello Gijs,

i did read and search in a book for Access with VBA , Programming etc....but
it doesn't work - i receive always an error also with =

I try to explain better now.

kunden_tbn (for all coustomers)
articel_tbn (for all items, products)
bestellungs_tbn ( for all orders )

i made a form with all fields of the bestellungs_tbn - including
coustomer_id.

in this form i put in combo boxes for coustomer_id, base on a query for all
infos for coustomers ( street,zip code, city etc...) this list contains all
coustomers and i can choose one - the coustomer_id can i put in the field.

after i put this coustomer_id, id like that access fill out the field,
street, zip code, city etc... for this coustomer.

i choose the field ( combo box ) for the coustomer_id and pressed
properties, i choose after update and the ...points - then i choose to
create a macro - set a name and start with setvalue - there are 2 fields for
setvalue ( down )

1. field: ??? i put in the field of the [Kunden_tbn].[KundenID.] - there
are the id to compare.
2: expr.: here i put in
=Dlookup([Kunden_ID];[Kunden_tbn];[Bestellungs_tbn].[KundenID]=[Kunden_tbn].
[KundenID])

after that i receive always the error " Kunden_tbn isn't found or contained
in the form.

Maybe its better in the bestellungs_form to out a button - i put the number
of the coustomer, then i press the button for a query of macro, that i can
search the coustomer date in a pop up form - then with a click to a button
in the pop up form i can put in the main_form ( bestellungs_form ) . an idea

thanks Peter
 
peter junker gebruikte zijn klavier om te schrijven :
Hello Gijs,

i did read and search in a book for Access with VBA , Programming etc....but
it doesn't work - i receive always an error also with =

I try to explain better now.

kunden_tbn (for all coustomers)
articel_tbn (for all items, products)
bestellungs_tbn ( for all orders )

i made a form with all fields of the bestellungs_tbn - including
coustomer_id.

in this form i put in combo boxes for coustomer_id, base on a query for all
infos for coustomers ( street,zip code, city etc...) this list contains all
coustomers and i can choose one - the coustomer_id can i put in the field.

after i put this coustomer_id, id like that access fill out the field,
street, zip code, city etc... for this coustomer.

i choose the field ( combo box ) for the coustomer_id and pressed
properties, i choose after update and the ...points - then i choose to
create a macro - set a name and start with setvalue - there are 2 fields for
setvalue ( down )

1. field: ??? i put in the field of the [Kunden_tbn].[KundenID.] - there
are the id to compare.
Click to expand...

No, this should be the field you want to fill in(the field that holds
the customer name on screen for example)
2: expr.: here i put in
=Dlookup([Kunden_ID];[Kunden_tbn];[Bestellungs_tbn].[KundenID]=[Kunden_tbn].
[KundenID])
Click to expand...

The first part now searches for Kunden_ID. You already know that one.
If you change it to Kunden_Name and change the last part to "[KundenID]
= [<name of your combobox>]" then, it would retrieve the Kunden_Name
from the table Kunden_tbn where the KundenID equals the Kunden_ID from
the combobox.

So, for example, you're form holds:

Kunden_ID (combobox called cmbKunden)
Kunden_Name (textbox called txtName)
Kunden_Adresse (textbox called txtAdresse)
undsoweiter

then the afterupdate-event of your combobox could fill in name and the
address with the macroactions:
SetValue
Kunden_Name
=DLookup("Kunden_Name", "Kunden_tbn", "Kunden_ID=" & cmbKunden)
SetValue
Kunden_Adresse
=DLookup("Kunden_Adresse", "Kunden_tbn", "Kunden_ID=" & cmbKunden)
 
Hello Gijs,
thanks again, but it doesnt work - dont understand why. !

field: 1st field: i put in!
[Vorname] - ( i have to choose from the table Kunden_tbn or the form? )

exp: 2nd field: i put in !
= DLookUp("[Vorname]";"[kunden_tbn]";"[KundenNr]" = &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
( combox field for
coustomer )

it doesn't work - access gives me an error message.


Did I understand right:
1 field - what i want to update
2 field - the command for the expr. - where the dates are and then to put
in.

The combo box field - based on a query returns with all dates of the
coustomers - after i did update only with the coustomer Id - the other -
Vorname,Nachname etc. is filled out automaticlly.

thanks peter






Gijs Beukenoot said:
peter junker gebruikte zijn klavier om te schrijven :
Hello Gijs,

i did read and search in a book for Access with VBA , Programming etc....but
it doesn't work - i receive always an error also with =

I try to explain better now.

kunden_tbn (for all coustomers)
articel_tbn (for all items, products)
bestellungs_tbn ( for all orders )

i made a form with all fields of the bestellungs_tbn - including
coustomer_id.

in this form i put in combo boxes for coustomer_id, base on a query for all
infos for coustomers ( street,zip code, city etc...) this list contains all
coustomers and i can choose one - the coustomer_id can i put in the field.

after i put this coustomer_id, id like that access fill out the field,
street, zip code, city etc... for this coustomer.

i choose the field ( combo box ) for the coustomer_id and pressed
properties, i choose after update and the ...points - then i choose to
create a macro - set a name and start with setvalue - there are 2 fields for
setvalue ( down )

1. field: ??? i put in the field of the [Kunden_tbn].[KundenID.] - there
are the id to compare.
Click to expand...

No, this should be the field you want to fill in(the field that holds
the customer name on screen for example)
2: expr.: here i put in
=Dlookup([Kunden_ID];[Kunden_tbn];[Bestellungs_tbn].[KundenID]=[Kunden_tbn].
[KundenID])
Click to expand...

The first part now searches for Kunden_ID. You already know that one.
If you change it to Kunden_Name and change the last part to "[KundenID]
= [<name of your combobox>]" then, it would retrieve the Kunden_Name
from the table Kunden_tbn where the KundenID equals the Kunden_ID from
the combobox.

So, for example, you're form holds:

Kunden_ID (combobox called cmbKunden)
Kunden_Name (textbox called txtName)
Kunden_Adresse (textbox called txtAdresse)
undsoweiter

then the afterupdate-event of your combobox could fill in name and the
address with the macroactions:
SetValue
Kunden_Name
=DLookup("Kunden_Name", "Kunden_tbn", "Kunden_ID=" & cmbKunden)
SetValue
Kunden_Adresse
=DLookup("Kunden_Adresse", "Kunden_tbn", "Kunden_ID=" & cmbKunden)

--
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Click to expand...
 
Na rijp beraad schreef peter junker :
Hello Gijs,
thanks again, but it doesnt work - dont understand why. !

field: 1st field: i put in!
[Vorname] - ( i have to choose from the table Kunden_tbn or the form? )
Click to expand...
The form
exp: 2nd field: i put in !
= DLookUp("[Vorname]";"[kunden_tbn]";"[KundenNr]" = &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
( combox field for
coustomer )
Click to expand...
Sounds almost OK. Move the equal sign inbetween the quotes :
"[KundenNr] = " &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
If KindenNr is a numeric field, this will work, otherwise (a textfield)
you'll have to use quotes :
"[KundenNr] = '" &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29]) & "'"

it doesn't work - access gives me an error message.

Did I understand right:
1 field - what i want to update Correct (on the form)
2 field - the command for the expr. - where the dates are and then to put
in.
Click to expand...
Correct. If you would put "1" there, it would fill the feilld with 1,
if you put a function there, the result of that function will be put
there
 
thanks again, try it
hope i find the way :-)))


Gijs Beukenoot said:
Na rijp beraad schreef peter junker :
Hello Gijs,
thanks again, but it doesnt work - dont understand why. !

field: 1st field: i put in!
[Vorname] - ( i have to choose from the table Kunden_tbn or the form? )
Click to expand...
The form
exp: 2nd field: i put in !
= DLookUp("[Vorname]";"[kunden_tbn]";"[KundenNr]" = &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
( combox field for
coustomer )
Click to expand...
Sounds almost OK. Move the equal sign inbetween the quotes :
"[KundenNr] = " &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
If KindenNr is a numeric field, this will work, otherwise (a textfield)
you'll have to use quotes :
"[KundenNr] = '" &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29]) & "'"

it doesn't work - access gives me an error message.

Did I understand right:
1 field - what i want to update Correct (on the form)
2 field - the command for the expr. - where the dates are and then to put
in.
Click to expand...
Correct. If you would put "1" there, it would fill the feilld with 1,
if you put a function there, the result of that function will be put
there

--
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Click to expand...
 
Hello Gijs,
yes, thanks it works - finally!!!

I hope you can help me with a other problem:

I made a form [bestellungen_Kunden] - in this form are the dates of the
coustomer, the invoiceId and date - also i want to write the
products -artikel etc...in this formular.

the things with coustomer, invoicenumber etc...is ok -

if i take the fields from the bestellungs_tbn ( articel, product, quantity
etc... ) and put the fields in the form i have the problem, that i can
choose all infos for the products, and also can fill out the fields, but if
i jump forward i jump through all products in the database.

I made a under-form, only for the articel infos - with a query - the same
problem, i see all the rows with articels.

for example :

1 / oil / modul / 10 Euro
the next row, if i had made a copy of that row is the same articel.
but how can i cancel, that if i have 10 rows, only the same articel is in
the rows, if i change it, then is the next artikel 10 times in the rows.

thanks Peter




Gijs Beukenoot said:
Na rijp beraad schreef peter junker :
Hello Gijs,
thanks again, but it doesnt work - dont understand why. !

field: 1st field: i put in!
[Vorname] - ( i have to choose from the table Kunden_tbn or the form? )
Click to expand...
The form
exp: 2nd field: i put in !
= DLookUp("[Vorname]";"[kunden_tbn]";"[KundenNr]" = &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
( combox field for
coustomer )
Click to expand...
Sounds almost OK. Move the equal sign inbetween the quotes :
"[KundenNr] = " &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
If KindenNr is a numeric field, this will work, otherwise (a textfield)
you'll have to use quotes :
"[KundenNr] = '" &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29]) & "'"

it doesn't work - access gives me an error message.

Did I understand right:
1 field - what i want to update Correct (on the form)
2 field - the command for the expr. - where the dates are and then to put
in.
Click to expand...
Correct. If you would put "1" there, it would fill the feilld with 1,
if you put a function there, the result of that function will be put
there

--
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Click to expand...
 
Hello Gijs,,

other question - if id like to update fields in a table, is this possible
automaticly?
for example - i put in the coustomer ID - after i did update the field, id
like to update based on the coustomer ID - all the dates directly in this
table, not in the form!
If i make the same code as in the form - and i change form into table - i
receive always the reply that access cant find the table ( bestellungen_tbl)
??

thanks peter

Gijs Beukenoot said:
Na rijp beraad schreef peter junker :
Hello Gijs,
thanks again, but it doesnt work - dont understand why. !

field: 1st field: i put in!
[Vorname] - ( i have to choose from the table Kunden_tbn or the form? )
Click to expand...
The form
exp: 2nd field: i put in !
= DLookUp("[Vorname]";"[kunden_tbn]";"[KundenNr]" = &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
( combox field for
coustomer )
Click to expand...
Sounds almost OK. Move the equal sign inbetween the quotes :
"[KundenNr] = " &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29])
If KindenNr is a numeric field, this will work, otherwise (a textfield)
you'll have to use quotes :
"[KundenNr] = '" &
Formulare![bestellungen-kundenformular]![Kombinationsfeld29]) & "'"

it doesn't work - access gives me an error message.

Did I understand right:
1 field - what i want to update Correct (on the form)
2 field - the command for the expr. - where the dates are and then to put
in.
Click to expand...
Correct. If you would put "1" there, it would fill the feilld with 1,
if you put a function there, the result of that function will be put
there

--
Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. When I snap my fingers, you cannot
imagine why you ever felt otherwise. <snap>
Click to expand...
 
peter junker drukte met precisie uit :
Hello Gijs,
yes, thanks it works - finally!!!

I hope you can help me with a other problem:

I made a form [bestellungen_Kunden] - in this form are the dates of the
coustomer, the invoiceId and date - also i want to write the
products -artikel etc...in this formular.

the things with coustomer, invoicenumber etc...is ok -

if i take the fields from the bestellungs_tbn ( articel, product, quantity
etc... ) and put the fields in the form i have the problem, that i can
choose all infos for the products, and also can fill out the fields, but if
i jump forward i jump through all products in the database.

I made a under-form, only for the articel infos - with a query - the same
problem, i see all the rows with articels.

for example :

1 / oil / modul / 10 Euro
the next row, if i had made a copy of that row is the same articel.
but how can i cancel, that if i have 10 rows, only the same articel is in
the rows, if i change it, then is the next artikel 10 times in the rows.

thanks Peter
Click to expand...

Sorry, you've lost me... I don't understand what you mean here.
But, is the products-subform bound to a query? if so, does the query
only retrieve the product from this customer?
 
peter junker had uiteengezet :
Hello Gijs,,

other question - if id like to update fields in a table, is this possible
automaticly?
for example - i put in the coustomer ID - after i did update the field, id
like to update based on the coustomer ID - all the dates directly in this
table, not in the form!
If i make the same code as in the form - and i change form into table - i
receive always the reply that access cant find the table ( bestellungen_tbl)
??
Click to expand...

You can't update a table this way... But if the field is on the form
_and_ bound to the table, the formvalue will be saved into the table if
you save the record (don't escape or close I mean)
 
Hello Gijs,

ok - i use the same form as the thing for update the coustomer dates after i
wrote in the coustomer ID.

How can I find a solution for the problem. I did programm a database with
the tbl: coustomer_tbl, product_tbl, invoice_tbl, order_tbl - for each tbl i
did make a form.

The form for the orders (coustomers ) are based on the dates of the
order_tbl - that hold all the dates what, when and who did order what, also
the invoicenumber etc.

All things work in the form, but for example I need 10 or 15 rows for the
products, that i can put in the article or product that a coustomer order.

I did take the fields based on the table ( all combobox fields ) - but if i
make 10 rows ( positions to order) and put one article in, all 10 rows hold
that equal article. I have to choose( with a query based on the product_tbl
the items ( that tbl hold all infos and fields for the items ) an put in
the fields of the form based on the order_tbl ???

If i cancel all fields based of the order_tbl, and put in new txt fields
also doesn't work !

In this form I d like to seize the items after a coustomer order anything,
then saved in the table of orders. Is the form ready with all dates i want
to klick a btn and a invoice is ready to print - the report works,based on
the dates of the table - if i fill all in the sheet of the table, it works.

The order_tbl has a field orderID - that is a automaticfield -value - so
each item need a new row.

Thanks Peter
 
peter junker schreef op 5-12-2004 :
Hello Gijs,

ok - i use the same form as the thing for update the coustomer dates after i
wrote in the coustomer ID.

How can I find a solution for the problem. I did programm a database with
the tbl: coustomer_tbl, product_tbl, invoice_tbl, order_tbl - for each tbl i
did make a form.

The form for the orders (coustomers ) are based on the dates of the
order_tbl - that hold all the dates what, when and who did order what, also
the invoicenumber etc.

All things work in the form, but for example I need 10 or 15 rows for the
products, that i can put in the article or product that a coustomer order.

I did take the fields based on the table ( all combobox fields ) - but if i
make 10 rows ( positions to order) and put one article in, all 10 rows hold
that equal article. I have to choose( with a query based on the product_tbl
the items ( that tbl hold all infos and fields for the items ) an put in
the fields of the form based on the order_tbl ???

If i cancel all fields based of the order_tbl, and put in new txt fields
also doesn't work !

In this form I d like to seize the items after a coustomer order anything,
then saved in the table of orders. Is the form ready with all dates i want
to klick a btn and a invoice is ready to print - the report works,based on
the dates of the table - if i fill all in the sheet of the table, it works.

The order_tbl has a field orderID - that is a automaticfield -value - so
each item need a new row.

Thanks Peter
Click to expand...

I think what you need is a datasheet-form instead of what you're using
right now. If you open that ordertable in datasheet form-view, you can
add as many records as you like (1, 10 or 25).
Set the for the ID to the correct orderID using the dlookup and fill in
other fields (with validation) as needed.
Look at the Northwind sample database (that can be installed with
access/Office). The Orders-form is a good example of what you're trying
to do.
 
Hello Gijs,
i thougt, that i can use the dlookup only in a form, not in the datasheet of
the table.

Can you send me a explanation of the code for the datasheet [dlookup= ( )]

Thanks Peter
 
Hello Gijs,

i did found the datasheet and it works to update the dates as in the normal
form - only one thing!

- - if i did update in the combobox field the coustomer ID and put it in
the other fields in this row are filled out with the dates of the coustomer.

After i put in or update the ID of the coustomer all rows are filled out
with this coustomer number ( for example Id 5 )

How can i put in the coustomer ID only for this row and not the rows under
the row i'm updating infos??

Thanks Peter
 
peter junker formuleerde op dinsdag :
Hello Gijs,

i did found the datasheet and it works to update the dates as in the normal
form - only one thing!

- - if i did update in the combobox field the coustomer ID and put it in
the other fields in this row are filled out with the dates of the coustomer.

After i put in or update the ID of the coustomer all rows are filled out
with this coustomer number ( for example Id 5 )

How can i put in the coustomer ID only for this row and not the rows under
the row i'm updating infos??

Thanks Peter
Click to expand...

It might be called continuous form. not datasheet...
 
Back
Top