Simple Way to Carry Over Value of Field to Next Form

[Heatshiver]

I need to upload a database to Sharepoint, so essentially I have no relationships, just LookUp Fields.

I have two tables, both sharing the Report Number field, datatype AutoNumber.

I want to have the Report Number on the first form displayed. Once the user has finished filling out information they can click a button to go to the second form. The Report Number will no longer be displayed, but the forms will all be part of the same report.



I need to have a simple way (w/o VBA) to transfer the value of the Report Number to the second form so that it knows it is all part of the same report.

I know that I can create a drop-down box so the user can select the Report Number, but my fear is that if there is a lot of reports (and there will be) that they could potentially forget what Report Number is being used and start filling out the wrong one.

Is there a way to carry the Report Number value over to the next form simply? Maybe a macro could do this?

Thank you.

[Robeen]

Using VBA IS a simple way of doing this.
Do you have a specific reason for NOT wanting to use VBA?

[Heatshiver]

From what I've read and been told, Sharepoint won't allow VBA, just macros.

[ketbdnetbp]

Heatshiver - Don't know if this is the easiest way but, if you go to the report number control on the second form and press CTRL and ' (Apostrophe), the value from the preceeding record will be displayed in the report number control of the new record. You should be able to do that with a macro, if vba is not an option.

All the best,

Jim

[Heatshiver]

Thanks Jim.

Any chance you would know how to go about putting this into a macro?

[ketbdnetbp]

Heatshiver - Unfortunately, I have only used 3 macros in the past 10 years, so, my macro experience is very, very, very limited. Other's, on this forum, would be in a much better position to provide assistance. However, you may want to Google, Sendkeys Macro, and see what comes up.

Best wishes,

Jim

[Robeen]

Using a Macro, you can [I'm assuming] use the 'Run Code' Action?

If so, then your Macro can 'call' the code that will still do the needful?

Try something like this:
In a Module, paste in this code:

Public Function Test()
MsgBox "Testing."
End Function

Then - in your Macro - do a Run Code action and put in 'Test()' to point it to teh Test() function . . .
Run the Macro and see if you get that Messagebox . . .

I seem to remember using this workaround when I was playing around with a Web Form for Sharepoint - but I can't remember what the outcome was.
Try it and let me know. I would like to know how you get this going.

[Heatshiver]

Thanks Robeen, but unfortunately SharePoint won't take VBA or modules.

[Robeen]

Ok.
Well - all the best.
Sorry I was not able to help!
I'd like to know how you get around this - because when I first tried to go the Sharepoint route, I remember we had to abandon one urgent project because I couldn't do what I knew how to do with regular Forms.