PC Review


Reply
Thread Tools Rate Thread

"button" / form not working

 
 
espee2
Guest
Posts: n/a
 
      10th Aug 2010
I made a simple button on one form to open another form. Both forms
are related and work fine manually (without the button) (I just
thought it would save a step) When I open that (second) form with the
button the fields/record are blank, but if I open the (second) form
manually, the fields are as should be. Wha'ts up with that?

I would really like it if, when I open the (second) form with the
button, it will display the same (ProductID) as the first form I was
filling in. but I will settle on just being able to click through the
records to the one I want...
 
Reply With Quote
 
 
 
 
espee2
Guest
Posts: n/a
 
      10th Aug 2010
On Aug 10, 4:04*am, XPS35 <xps...@gmail.com> wrote:
> espee2 wrote:
> > I made a simple button on one form to open another form. Both forms
> > are related and work fine manually (without the button) (I just
> > thought it would save a step) When I open that (second) form with the
> > button the fields/record are blank, but if I open the (second) form
> > manually, the fields are as should be. Wha'ts up with that?

>
> > I would really like it if, when I open the (second) form with the
> > button, it will display the same (ProductID) as the first form I was
> > filling in. but I will settle on just being able to click through the
> > records to the one I want...

>
> Hard to teel what is wrong without knowing the code behind the button.
>
> Anyway, it should look something like:
> DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID
>
> --
> Groeten,
>
> Peterhttp://access.xps350.com
>
> --- news://freenews.netfront.net/ - complaints: n...@netfront.net ---


I just used the wizard that pop's up when you add a button with the
toolbar.... where should I put that code?
 
Reply With Quote
 
espee2
Guest
Posts: n/a
 
      10th Aug 2010
On Aug 10, 10:58*am, espee2 <usenet.es...@gmail.com> wrote:
> On Aug 10, 4:04*am, XPS35 <xps...@gmail.com> wrote:
>
>
>
>
>
> > espee2 wrote:
> > > I made a simple button on one form to open another form. Both forms
> > > are related and work fine manually (without the button) (I just
> > > thought it would save a step) When I open that (second) form with the
> > > button the fields/record are blank, but if I open the (second) form
> > > manually, the fields are as should be. Wha'ts up with that?

>
> > > I would really like it if, when I open the (second) form with the
> > > button, it will display the same (ProductID) as the first form I was
> > > filling in. but I will settle on just being able to click through the
> > > records to the one I want...

>
> > Hard to teel what is wrong without knowing the code behind the button.

>
> > Anyway, it should look something like:
> > DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID

>
> > --
> > Groeten,

>
> > Peterhttp://access.xps350.com

>
> > --- news://freenews.netfront.net/ - complaints: n...@netfront.net ---

>
> I just used the wizard that pop's up when you add a button with the
> toolbar.... where should I put that code?


Duh! I figured out where to put the code and it works fine, BUT... it
only works in "edit" not entry (It won't work if I enter info into
form 1 and press the button, I have to close the form and re-open or
go to another record and come back... any help on that? thanks!!!!
 
Reply With Quote
 
XPS350
Guest
Posts: n/a
 
      10th Aug 2010
On 10 aug, 20:51, espee2 <usenet.es...@gmail.com> wrote:
> On Aug 10, 10:58*am, espee2 <usenet.es...@gmail.com> wrote:
>
>
>
> > On Aug 10, 4:04*am, XPS35 <xps...@gmail.com> wrote:

>
> > > espee2 wrote:
> > > > I made a simple button on one form to open another form. Both forms
> > > > are related and work fine manually (without the button) (I just
> > > > thought it would save a step) When I open that (second) form with the
> > > > button the fields/record are blank, but if I open the (second) form
> > > > manually, the fields are as should be. Wha'ts up with that?

>
> > > > I would really like it if, when I open the (second) form with the
> > > > button, it will display the same (ProductID) as the first form I was
> > > > filling in. but I will settle on just being able to click through the
> > > > records to the one I want...

>
> > > Hard to teel what is wrong without knowing the code behind the button..

>
> > > Anyway, it should look something like:
> > > DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID

>
> > > --
> > > Groeten,

>
> > > Peterhttp://access.xps350.com

>
> > > --- news://freenews.netfront.net/ - complaints: n...@netfront.net ---

>
> > I just used the wizard that pop's up when you add a button with the
> > toolbar.... where should I put that code?

>
> Duh! I figured out where to put the code and it works fine, BUT... it
> only works in "edit" not entry (It won't work if I enter info into
> form 1 and press the button, I have to close the form and re-open or
> go to another record and come back... any help on that? thanks!!!!


Add an extra command:

Me.Refresh
DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID


Groeten,

Peter
http://access.xps350.com
 
Reply With Quote
 
railcrew
Guest
Posts: n/a
 
      10th Aug 2010
On Aug 10, 12:23*pm, XPS350 <xps...@gmail.com> wrote:
> On 10 aug, 20:51, espee2 <usenet.es...@gmail.com> wrote:
>
>
>
>
>
> > On Aug 10, 10:58*am, espee2 <usenet.es...@gmail.com> wrote:

>
> > > On Aug 10, 4:04*am, XPS35 <xps...@gmail.com> wrote:

>
> > > > espee2 wrote:
> > > > > I made a simple button on one form to open another form. Both forms
> > > > > are related and work fine manually (without the button) (I just
> > > > > thought it would save a step) When I open that (second) form withthe
> > > > > button the fields/record are blank, but if I open the (second) form
> > > > > manually, the fields are as should be. Wha'ts up with that?

>
> > > > > I would really like it if, when I open the (second) form with the
> > > > > button, it will display the same (ProductID) as the first form I was
> > > > > filling in. but I will settle on just being able to click throughthe
> > > > > records to the one I want...

>
> > > > Hard to teel what is wrong without knowing the code behind the button.

>
> > > > Anyway, it should look something like:
> > > > DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID

>
> > > > --
> > > > Groeten,

>
> > > > Peterhttp://access.xps350.com

>
> > > > --- news://freenews.netfront.net/ - complaints: n...@netfront.net ---

>
> > > I just used the wizard that pop's up when you add a button with the
> > > toolbar.... where should I put that code?

>
> > Duh! I figured out where to put the code and it works fine, BUT... it
> > only works in "edit" not entry (It won't work if I enter info into
> > form 1 and press the button, I have to close the form and re-open or
> > go to another record and come back... any help on that? thanks!!!!

>
> Add an extra command:
>
> Me.Refresh
> DoCmd.OpenForm "Form2", , , "ProductID=" & Me.ProductID
>
> Groeten,
>
> Peterhttp://access.xps350.com


That did it!! Thanks a million!!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Add Field" button under "Customized Form" stop working??? Troika Microsoft Outlook BCM 3 4th Mar 2008 11:18 PM
"Add Field" button under "Customized Form" stop working??? Troika Microsoft Outlook Form Programming 1 4th Mar 2008 01:17 AM
"Design This Form" button not working =?Utf-8?B?QnJpZGdldA==?= Microsoft Outlook Discussion 0 25th Oct 2006 08:06 PM
"Save Record" button not working after adding "Edit" button. Viken Karaguesian Microsoft Access 2 31st May 2006 02:30 AM
Submit button not working on a method="get" form after DataBind martyn_wynne@hotmail.com Microsoft ASP .NET 2 7th Feb 2005 05:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:42 PM.