Search results

I might be wrong ... but I think what you need is to change in the record source for your report the word INNER to RIGHT

In the properties of you combo box you need to put on change event a call for your sub Private Sub cboStatus_Change() Call Form_Current End Sub

Check if you placed the details instead of details section some other place

If you have in a table some field which will bear the same code to identify the case then everything is possible. Ex. #| Code| Division| Address1| ------------------------------------- 4 BUJO Pre TX 5 BULA Wif TX 2 SMJO Cit AL 3 SMPA Gov VN 6 SMSA Cit WA 7 SMSA Cit NB 1 SMSM Cit Min As...

ok ... your cropped copy didn't explain anything ... I am assuming that you have a form with some fields to filter records and also among filtered records you need to know how many of them are "checked". create a query with selection criteria referencing to your form fields plus...

Hmmmm ... I am not sure what is the problem. As an example I am giving you what is in my db. When I went Tools,Office links, Analyze with Excell it worked like a charm ... no problems See attachment -the "ContractID" field is number yet it displayes the text ... when I output the table...

can you make a print screen of your form to see how it works ?

Is not the record navigation bar display number of records queried/filtered/selected ?

here we go.

In on change event of your combo box put somthing like this. Private Sub Yourcombobox_Change() Forms.Yourmainform.YourtextField.Value = Me.Yourcombobox End Sub

can you post a db? Sounds like you have problem with bound columns

Now create an append query. In design of this query in "field" grid type something like this 1: Forms!Yourformname!Yourcomboname Do so for every other field you need. Save a query In "append to" select the field into which you will append this data. Now on the form put the button (use wizard...

This thing is actually working properly. The thing is that value has not been changed because you just cleared the combo box .... so even if you cleared the combo box and tries to leave the field it still has the same value as the first combo.

In the properties of the subform select the default view of it as a pivot .

Difficult to say without seeing the form itself but look at when your subform gets refreshed. Your subform probably has two fields listed in the parent/child property. Does the sequence of actions make any difference for the form ( I mean if you try to select the second field then first or vice...

:) No but you can change your object property ( tables, forms ...) to "hidden". and if you, in a dbase, do not "request" to see hidden object u will not see them :) Why don't you see the forms Hmmm ... I don't know ...weird

to make it easier can you post your db ?

I am puzzled here . You want access to record blank entry ? Why ?

By closing the form you are saving the record If everything is filled on the form correctly ( according to the rules ) access will save record and close the form silently. if not ... it will swear and let you know why it doesn't like your entries. :)

:) Select this function and click on the 3 dots to the right, copy the code to the thread to see what the function is doing