form to form copy

[Carmell]

Not a programmer. Have tried solutions in archive. Still a no go. Help appreciated.
Have a continuous entry form "Numbering Entry" my goal is to have a second form popup from a button (accomplished this part) then to have certain fields from the original "Numbering Entry" form duplicate/copy to the new 2nd form "Labels". Problems may stem from these facts.
1) its a continuous form? - yes, the 'button' to pop up the 2nd form shows on EACH form - but does the new popup form 'know' which of the continuous records?
2) one field is an autonumber field? (the id field in fact)

I'll then use the 2nd form with only two fields to "print" on a label.
operator will enter a record - popup - print label
enter a record - popup - print label
get the idea? thanks for the help.

 

[kathryn]

Is there any reason why the button, instead of popping up a second form, can't print the label directly?

As to your first question, YES, the form does know what record you are on when you click the button.



Kathryn

 

[ray436]

Hi,

I'd like to add to the above if possible...... I have a similar situation, but my popup is used to open a sort of rolodex of our clients, so the person data entering on the main form can get to their client-code and account info. I would like to be able to copy some of the data to the main form, but you cant work the main form when the popup is open. I dont have the data available on the main form since i don't want all users to have access to the info ( the popup is not made available to all users in their permission set)

is there a way to link the data to the main form, but only allow some users access to the table - or would this not work? ( you would just get an error on opening?)

thanks..

ray

 

[tmh]

I have a similar situation as well. I am trying to get data from a main form to another form I open when "not in list" is activated. You can get data from a different form that is open by setting the default value of the form like this in the property settings.

=[Forms]![Main Form]![INSTCATBOX]

The Main Form is the name of my form I am copying from. The instcatbox is the box where the data is that I want on the form when it opens.

MY PROBLEM IS THIS. I am trying to open a new form when "not in list" is activated. I am having trouble passing the NewData value in the current field firing the "not in list" command. The above only works after the combo box with the data has "lost focus". Any suggestions?

 

[ghubbell]

Carmell:
One Command button in the continuous forms' "Form Footer". Name it "CmdLabel". In its "On Click" event (in VB) have it open up your label report...But the query for your label report is based on criteria from your continuous form...underneath the ID field you have criteria that is like:
[Forms]![TheNameOfTheForm]![TheNameOfTheIDFieldOnThatForm]

Ray:
Set the fields of data you don't want shown as .Visible = No or .Locked = true depending on the user. You should do this in the "On Open" or "On Load" event:
If CurrentUser() = "Ray" Then
Me![NameOfAField].Visible = True
Else
Me![NameOfAField].Visible = False
End if
You could carry some of this "hidden" info in other columns of a combobox (width of column = 0) for your client and when the client is selected from the combo (after update) you could do:
Me![NameOfField1] = Me![NameOfCombo].Column(1) ...

Remember comboboxes' columns are zero based so the first column in its shown query is column 0.
You may have to adjust your "security" to do so. Then you won't need the pop up!

tmh:
In your NotInList event:
Response = acDataErrContinue
DoCmd.OpenForm "NameOfYourForm"

OK everyone...go to it! Gord
ghubbell@total.net