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.

 

[The_Vincester]

It's pretty easy overall.

Let's say the name of the control on the first form is "Report Number". For that matter, it can also be called "Report Number" on your second form as well, for consistency.

The name of the first form is "First Form", and the second is "Second Form."

You already have your method of opening the second form, so on the On Load event on the second form, put:

me.[Report Number] = [Forms]![First Form].[Report Number]

It just says, for my Report Number control, go to the First Form and insert the value that's in the Report Number control.

The caveat is that the First Form must be open to pull the value, but it sounds like you're already doing that.

 

[Heatshiver]

I will try this out as an expression and hopefully it will work.

 

[The_Vincester]

I just noticed a couple of things about your question. You noted "without VBA," and you also mentioned Sharepoint.

Are you using Access for any of this, and if so, why no VBA?

 

[Heatshiver]

I am using Access but it needs to be on SharePoint.

From everything I have read you cannot use VBA or modules when using SharePoint.

The database itself can if downloaded, but if being used online, the VBA/modules will not be seen or used by SharePoint.

Someone mentioned the AutoKeys macro and using CTRL and APOSTROPHE, but I am unsure how I would set this up yet.