New Member - Hello!

[mkchipper]

Hi Everyone,

By way of introduction - I am retired from a career focused on financial systems, and enjoying my life here in the USA (politics aside)! Go Birds!!!!

I have many hobbies and interests which includes ACCESS programming. I really enjoy keeping "sharp" with the challenges of coding and have recently been working on an application for my local tennis shop.

I am hoping to both contribute and learn as well as continue to develop by programming skills. It is really fun ... well that is until you reach a road block! LOL

Thanks!

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[The_Doc_Man]

Hello and welcome to the forums.

 

[mkchipper]

My first question right out of the box is.... what are the things I can check when I have a data entry subform that will not display more than one line ? I have spent hours checking some many possibilities i.e.
Link fields
queries and references to controls
etc.
The background is
I have a main form(frmservice_orders_Now) with a subform(sbfservice_type_details). The PK field for the table( Service_Orders_Main) on the main form is the ORDER_ID. This PK is a number field. The FK for the subform table (Service_Order_Detail) is ID and is an autonumber field.

The Main Form (and subsequently subform) are opened from another form as follows:

DoCmd.OpenForm "frmservice_orders_now", acNormal, "","1-0", ,acDialog, varOrder_ID & ";" & varCustomer_num etc.
a series of variables using OPENARGS.

The main form opens properly and populates the fields passed to it.

The ORDER_ID was obtained by this code which follows the DoCmd

DoCmd.SearchForRecord, "", aFirst, "[Order_ID] = " & Nz(DMax("[Order_ID]", Form.Recordsource), 0)

So.. I do not know at this point, if the way the form is opened is causing the problem, the queries or links to the forms or even some control on the subform that is hindering the ability of the subform to alloe mutliple line entry.

Any suggestions of what to look would be greatly appreciated.

 

[theDBguy]

Hi. Welcome to AWF!