Create a command button (New record in Sub form)

[djspod]

Hi,



Is it possible to create a button for a new record within the sub forms?

Ideally I would like to have one for each sub form and not add a new record to the main form. (Hide the record selectors)

[June7]

Can set the subform as Continuous and arrange controls to look like datasheet then put button in header section.

[Missinglinq]

Not really sure what you mean by "...and not add a new record to the main form..." but you realize that the Records added to the Subforms will have to be related to the Current Record on the Main Form, right?

Triggering an action, in a Subform, can be done as June7 has advised, with a fair amount of grunt work, tweaking a Continuous Form to look like a Datasheet, or you can simply use the DoubleClick event of one or more Textboxes to act like a Command Button.

Linq ;0)>

[djspod]

Thanks for the replies,

Just to clarify, The Main Form has a 2 subforms within it, FrmShortage Main Form.

The ShortageID field (Parent) links to each sub folders and their tables.

the idea is the operative opens a new form record (Shortage record main form) and there are many Inbound shortages from various sites and an Outbound Shortages sub form for many Outbound shortages.

At the moment the user can select the new record selector on either Sub Form and get straight to the bottom of the list to a new record, I was hoping to keep the Datasheet view I have at the moment with a command button to perform that function and get rid of the selector controls.

Thanks for your help

[June7]

Did you try suggestion?

[djspod]

Hi June,

I have set the sub form to continuous and moved the controls and labels to horizontal.

However the form now looks a little strange and the drop downs look weird,maybe I have done it wrong or got the wrong idea?

Apologies as I am still learning.

Thanks

[June7]

Try resizing height of controls.

[djspod]

https://drive.google.com/file/d/0B6r...ew?usp=sharing

[djspod]

Thanks again June7, that has done the trick just as you said!!

I now need to find a way to shape the form to look better so you can read the information box and that the combo fields don't look strange.

[June7]

The Information box should show a vertical scroll bar when it gets focus and input wraps to multiple lines.

What is strange about the comboboxes?

[Missinglinq]

...I now need to find a way to shape the form to look better so you can read the information box and that the combo fields don't look strange...

As I said

...Triggering an action, in a Subform, can be done as June7 has advised, with a fair amount of grunt work...

With the emphasis being on with a fair amount of grunt work; it does take quite a bit of tweaking to make a Continuous Form look like a Datasheet Form! Or, as I also said, you can keep your current Datasheet Form and simply tell your users to Double-Click on a given Textbox to add a New Record, with code like this, for each 'triggering' Textbox:

Private Sub InboundShortagesTextbox_DblClick(Cancel As Integer)
  DoCmd.GoToRecord , , acNewRec
End Sub

If desired, you could set up this same thing for several Textboxes, if that would make it easier on your users, instead of just one Textbox.

Linq ;0)>

[djspod]

Thanks for your help Missinglinq