add a record from macro

[Stephen]

I have on working table which is all I need

two forms doing input as needed one is a start form I input a date value
in this box and have several command butons controled by macros all work
as needed

one macro runs a query to find a matching record against the table if it
can not find the date it returns a blank form correctly. I close it then
want to add the value to the next record in the date field

My problem is I can not seem to transfer by micro or query this value

can you help?

thanks