copying data

[andrewleith1]

im creating a fault logging databse, i have a form that shows all the "machines" details, (including its previous faults in a subform)
i have another form for inputting new faults.
what i want to be able to do is when you click on the "log new fault" the form will open up with some of the same details as the machine i was just looking at. e.g. it will auto copy over the "machine number" and "machine serial"
thanks

 

[MStef]

Why you inputting a new foults (records) via another form.
Do it via subform.

 

[andrewleith1]

i already have a sub from displaying all the machines faults in the form that displays the machines details.
so could i use 2 subforms?

i was wanting the new fault to be logged via a pop up form, rather than it being on the same window.

can i use a button to change between all the faults being displayed and a log new fault form, within the subform?

im real rustys at this aint used access since i was at uni a few years ago!

 

[MStef]

You can us 2 subforms, but you don't need 2 subforms.
Do it via subform you already have.

 

[andrewleith1]

i know i could just use the one subform that displays all the faults in a table. and just add a new fault in.
however i want there to be a seperate form(using the tabs) that looks more like an input form, than just a table.