Formularfelt til rapport

There are a couple of possibilities!
One is to have three global variables where you save the information from the three fields on form 1. Then when you open form 2 you use these global variables.

Another idea is to put these three variables into a string seperated by a ; (example) then when you open form 2 you send the string containing the three variables in the OpenArgs parametere of the Docmd.openform method

Then you will need to split the string up into three seperate vraibales again!

but we cant help if you dont give some feedback!

hello......

oooooops. Jeg havede et "major breakdown" på min PC.(lidt virus og sådan), så jeg skulle starte helt fra bunden med min PC, men nu er jeg tilbage for fuld drøn.
Dit svar TERRY er sikkert et godt et, men jeg forstår det ikke (jeg=databasenød).
Gider du uddybe det?
Undskyld svartiden, meeeeeeeeeen bedre sent end aldrig

/Y

yadyam>if you dont know mauch about Access it isnt easy to explain!
The values you have selected can be placed into GLOBAL (public) varaiables, these variables can be used anywhere in your program.

In a module you can declare public variable like this

Public Price As Double

Then you can use price anywhere in your program. Yoo can also refer to fields on form1 FROM form2

forms!frm1.cboVareGruppe

OK terry, jeg prøver lige og se om jeg kan. Er det iorden jeg ikke lukker spørgsmålet endnu?

/Y

Helt i orden

hmmm, jeg er åbentbart dummere end gennemsnittet, kab du evt. uddybe hvor jeg skal oprette disse globale variable.
Hvad er Public Price As Double?
Og hvor skal jeg skrive forms!frm1.cboVareGruppe?

/Y

In the database window you can choose to create a new module.

Public means that the variable can be "seen" everywhere in the program. If it was Private it can only be seen in the module wher it is created.
Price is the name of the variable

As(som) Double is the data type which can hold a number such as 12345,67


forms!frm1.cboVareGruppe was only an example!

yadyam>Its going to be hard going if you dont understand what I mean, wouldnt it be a better idea to get hold of a book on Access?

Jeg har fået fat på en bog om ACCESS, og går nu igang med at læse den grundigt igennem.
Tak for hjælpen terry

/Y

that was quick :o)
and thanks

har haft den hele tiden, men forstår den ikke HELT!
;-P
/Y