Cbo and data entry Subform conundrum

[ali_g]

Hello Helpful People Out There!

I am new to this forum, and am wondering if anyone can help with a problem Im having with an Access 2000 database. I'm relatively new to access, but have stumbled my way through making an application - even venturing as far as some vb features, but Ive finally got a problem Im stuck on.

Basically, I'm wanting to do something that I believe is possible to mock up - A form with two subforms - the two sub forms are based on the same query and fields, but the bottom one is set to continuous, with the one above as a single form set to data entry - basically as described in this post on this forum.

http://www.access-programmers.co.uk/forums/showthread.php?t=123636&highlight=subform+data+entry+continuous+record

However, this is not working for me. I believe it is because I am using a cbo combo lookup box to select the client ID, which then displays the info in the main form and continuous form, and should tie in the single sub form for data entry. However, the data entry subform simply displays the first record that also features in the continuous subform, rather than a blank new record.

Ive simplified the database to only include the relative tables, queries, macro and forms/subforms to display the problem and I would be really greatful if anyone could have a look and maybe help me out, as Im at the point where Im thinking I will just have to suffer the continuous subform alone.

Many thanks

Ali

 

[motleyjew]

Try this. I created a combo lookup through the combo box wizard to search for the records instead of the way you were using it. I put the combo box on the upper right side of the form. I think this is what you were looking for.

 

[ali_g]

Thanks so much motleyjew, this seems just the ticket!

 

[nana]

How to display the details on the subform below?

Hi,

I would to know how do you display the details on the subform that you created? I have been trying to do it, but it doesn't work for me.

Please let me know how to do it cos I totally have no idea about it.

Thank you!

 

[motleyjew]

I am assuming that you are refering to the text on the bottom in the status bar. If that is the case, each field has a property called "status bar text". You need to fill this in each propertiy for each text box. If thats not, I'm not sure what detail you are refering to.

 

[nana]

Hi,

actually i'mb refering to the subform(fsubPickup1 & 2). How do you get the detail from the tables and display it in this subform?

Thank you.

 

[motleyjew]

His Main form is called frmPickup2. On that form he has the 2 subforms which are called fsubpickup1 and fsubpickup3. If you left double click on the edge of the subform in design mode you will notice a field that says Link Master Fields and another field that says Link Child Fields. He has ClientID in both of these fields. What he is saying is that the field called ClientID is what links the forms together. So when he is on whatever clientid in the main form, the clientid in the subforms will be shown as well. The difference between the 2 subforms that he is showing is fsubpickup1 is set to singleforms and he is able to add to the records. The other subform is set to continuous forms and show all the records related to the chosen clientid but can not add records. Hope that made sence.

 

[nana]

Hi,

thanks for the information.

But do you have any idea how can I calculate the amount. For example, in frmAsset: there is quantity. frmStock: there is availability, quantity_lost, quantity_loan.

I would like to calculate the availability using (quantity from frmAsset)-(quantity_lost)-(quantity_loan).

Mind if you could help me with that?

Thank you!

 

[motleyjew]

Ok, so I assume you are referring to another database that you are working on. Where do you want to see the result of this, on your form? Are you using subforms? Do you want to see it in a query. Some more info would help out. If you could attach the database would even be better.

Gregg

 

[nana]

Hi Greg,

i have attached the copy but was doing halfway. Still trying to figure out. So some are not neatly link. It's all mess up.

Actually, what i need is to calculate the Availability for frmStock, dispay in the subform of frmAsset_stock.

Details of quantity: Availability(frmStock)= Quantity(frmAsset)-QuantityLoan(frmLoan)-QuantityLost(frmLoan)+QuantityReturn(frmLoan).

Thank you so much.
Nana